ColdFusion 10 / MSSQL 2012 AlwaysOn / Data Direct Drivers

[Neo Rye]

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.

[SCAIFEA]

Have you tried the Easysoft Driver?

http://www.easysoft.com/products/data_access/jdbc_odbc_bridge/index.html

[Charlie Arehart]

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.)