I tried installing and using the new SQL 2005 JDBC 1.1 driver and read and
followed the technote at
[url]http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=ded4216b[/url]. I get
multiple error messages each time I try to connect using RDS. After the
messages aredismissed it works ok. The settings I used for this Datasource were:
1. JDBC URL= jdbc:sqlserver:// SAIC-C549F42BF7 :
1433;DatabaseName=MwsDevSqlServer
2. Driver Class= com.microsoft.sqlserver.jdbc.SQLServerDriver
3. Driver Name= SQL 2005 JDBC 1.1
4. A standard User Name & Password
The previous Datasource I used, which I went back to is a Microsoft SQL Server
driver:
1. Database =MwsDevSqlServer
2. Server=SAIC-C549F42BF7
3. Port= 1433
4. A standard User Name & Password

Ideas to fix?