8.0.1 64-bit SQL Server Connection Problems

[JNokes]

We are running an instance of SQL Server 2005 with a new installation of CF 8.0.1 64-bit on Windows 2008 64-bit VMWare.

We are unable to connect to our SQL Server 2005 database instance via CF admin. After having problems connecting through CF admin, I tried to connect via Windows ODBC Datasources and had the same issue. I was finally able to connect when I turned off “Dynamically determine port” and hard-coded the instance port (SQL instances do not run on port 1433, they are assigned by SQL or the admin). In Windows 2008 32-bit (and Windows 2003 32-bit) I leave “Dynamically determine port” checked on and it works fine. It is only the 64-bit version that does not work with this left on.

So, thinking I figured it all out, I changed the CF datasource TCP port from 1433 to our instance port (1462), but it still didn’t work. The same datasources work in 8.0.1 32-bit (set on port 1433), but not the 64-bit version (either on port 1433 or 1462).

Anyone have ideas on how to connect to SQL via CF admin in this scenario?

[Guest]

Hi,

Could you please try creating sql server datasource using 'Other' as the driver type? The connection string that you have to pass in should be of the format,
"jdbc:macromedia:sqlserver://[host]:[port];databaseName=[database];SelectMethod=[selectmethod];sendStringParametersAsUnicode=[sendStringParametersAsUnicode];[args]"

And, Please 'Enable Robust Exception' and provide me the exception stack trace that you get while configuring SQL datasource via CF Admin.

Thanks,
Hareni
Adobe CF team

[JNokes]

Are the JDBC SQL drivers installed by default or do I need to install them? When I try to connect using "jdbc:microsoft:sqlserver://SQL2005\OurInstanceName:1433;DatabaseName=OurDBName" and
"com.microsoft.jdbc.sqlserver.SQLServerDriver" as the Driver Class it says "No suitable driver available for DSTest, please check the driver setting in resources file, error: com.microsoft.jdbc.sqlserver.SQLServerDriver".

Are there SQL Server 2005 JDBC drivers for Windows 2008? I do not see them anywhere on microsoft.com. Are there different versions for 32-bit and 64-bit?

Thanks for your help!

[JNokes]

UPDATE: I installed Microsoft SQL Server 2005 JDBC Driver 1.2 according to instructions on this page: http://kb.adobe.com/selfservice/viewContent.do?externalId=ded4216b, but still get the same results ("No suitable driver available for DSTest, please check the driver setting in resources file, error: com.microsoft.jdbc.sqlserver.SQLServerDriver"). I tried this both on 32-bit and 64-bit Windows 2008, CF 8.0.1.

[JNokes]

UPDATE: I went through http://kb.adobe.com/selfservice/viewContent.do?externalId=ded4216b again, noticed I had a couple things wrong, and did get everything to connect. I'll let you know how it goes.