My how the years fly and things change.
Even in 2017 I still find value in making quick enterprise applications in Coldfusion. However the world is a changing, many of my endpoint are beyond the boundaries of my corporate firewalls.
I have ended up with a ton of nodeJS webservices endpoints running as docker containers in Azure jamming away data in Azure SQL. I want Coldfusion to be able to utilize that data.
The Solution
The solution is stupid easy… you can use the native Microsoft SQL Driver, no need to mess with anything else.
Go ahead put in the basics
- Database: Name as shown in Azure
- Server: something.database.windows.net
- Port: 1433
- Username: <sqlaccountname>@<databasename>
- Password: <password>
Then for the secret sauce
- Hit Show Advanced Settings
- In the connection string put the following:
EncryptionMethod=SSL;Encrypt=yes;TrustServerCertificate=no;
Note: Encrypt=yes may not be needed but since its working I am not touching it.
And that’s it!
If this was helpful or have a way to make it better? Let me know in the comments.
-Eric