Secure Datasource Settings in CF10
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.