Thanks for the reply @Terry_Whitney, but as I suspected, I can specify a DSN using code in the application.cfc and set the connection string to include either trustServerCertificate=true or encrypt=false and get the connection to work.
this.datasources["test"] = {
class: 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
, bundleName: 'org.lucee.mssql'
, bundleVersion: '12.2.0.jre11'
, connectionString: 'jdbc:sqlserver://localhost:1433;DATABASENAME=mydatabasename;SelectMethod=direct;trustServerCertificate=true'
, username: 'myusername'
, password: "mypassword"
// optional settings
, clob:true // default: false
, connectionLimit:-1 // default:-1
, liveTimeout:15 // default: -1; unit: minutes
, validate:false // default: false
};
I tried to look at the extension in github, but I either could not find the right version, or simply do not understand how these are built. The one in the master branch is for version 8.4.1.jre8. I wanted to see if I could edit the admin interface to include missing options in the connection string for the more recent drivers.
I presume that this affects all the versions 10+ of the driver as that is when encrypt=true was set as the default:
How are others using the more recent MSSQL JDBC drivers and how can I try to update the extension to include additional attributes?