Skip to main content
September 12, 2012
Question

Secure Datasource Settings in CF10

  • September 12, 2012
  • 1 reply
  • 1604 views

I am unable to create a secure datasource connection in CF10.  I am familiar with setting up secure datasources.  I have been setting them up since version 6.  In CF10, I have tried the JTDS driver, Microsoft JDBC driver, and built in driver with no success.  The datasources always verify correctly, but I can't do any queries without getting an exception.   The CF exception is coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.   Looking at the logs from the MSSQL server i see  this message..."The prelogin packet used to open the connection is structurally invalid; the connection has been closed.".  I have tried JDBC drivers that worked on CF9 and I have tried downloading the new JDBC drivers.  Has anyone else been able to created an encrypted datasource connection in CF10?  I installed using the secure profile option and it is the Enterprise version of CF.

This topic has been closed for replies.

1 reply

September 15, 2012

Problem resolved.  Turns out it is related to the JRE that is released with CF10.  Starting with version 1.6_29, you will not be able to connect to your SQL server if it isn't patched.  I applied the previous JDK and set coldfusion to use it.  This fixed my problem.  You could also patch your SQL Servers. http://support.microsoft.com/kb/2653857

12Robots
Participating Frequently
September 15, 2012

>> You could also patch your SQL Servers. http://support.microsoft.com/kb/2653857

Doesn't that seem a wiser solution than the one you chose?

jason

Inspiring
September 19, 2012

Actually it is recommended to use default JDK version shipped with CF server and for CF 10, it is Jdk 1.6.0_29.

Kaif