ColdFusion 10 / MSSQL 2012 AlwaysOn / Data Direct Drivers

Question

When is ColdFusion 10 going to officially support MSSQL 2012? Specifically the "AlwaysOn" Availability Groups and the connection flag "ApplicationIntent=ReadOnly" or "ApplicationIntent=ReadWrite"? The JDBC driver from Microsoft supports it and I believe DataDirect has a new driver that supports it, but it doesn't seem available yet in CF10 and the latest Update 8. I tried running the Microsoft specific JDBC driver, but ran into differences in resultsets.

Charlie Arehart · Answer

FWIW, the applicationintent field was added in the CF2016 admin DSN setup, at least for the built-in drivers (from Datadirect/Progress). When using the downloaded ms driver instead (implemented as an "other" type in CF), you would add that applicationintent as a connection string in the CF Admin instead. (CFQUERY and related tags did not add an applicationintent attribute.)

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.