Skip to main content
J
JNokes
Participating Frequently
April 10, 2008
Question

8.0.1 64-bit SQL Server Connection Problems

  • April 10, 2008
  • 2 replies
  • 717 views
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?
This topic has been closed for replies.

2 replies

J
JNokesAuthor
Participating Frequently
April 11, 2008
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.
A
Anonymous
April 11, 2008
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
J
JNokesAuthor
Participating Frequently
April 11, 2008
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!
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices