We're experiencing some strange behavior in CFAdmin setting up a datasource to a SQL 2k8 server.
Datasource sets up fine on 32 bit machine. And we've had 2 64-bit Win7 instances able to setup the DSN successfully as well. But this one system just won't cooperate. It throws: Connection verification failed for data source: dbnamehere java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "dbnamehere" requested by the login. The login failed. The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "dbnamehere" requested by the login. The login failed. We found a post that suggested that the JRE needed to be upgraded or switched to the full JDK (it was already the JDK) for multi-language support. We looked into that. Still no success. What fixed the immediate issue: Copied the neo-datasources.xml from another system. The datasources work fine. But we still can't create new datasources to SQL 2k8 servers. Thoughts? Cheers, Kris ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333876 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
