tracker issue : CF-3630461

select a category, or use search below
(searches all categories and all time range)
Title:

MSSQL 2012 Support

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Dave DeVol / Dave DeVol (Dave DeVol)

Created: 09/11/2013

Components: Database

Versions: 10.0

Failure Type: Usability Issue

Found In Build/Fixed In Build: Final / 286449

Priority/Frequency: Major / All users will encounter

Locale/System: English / Win 2008 Enterprise Svr

Vote Count: 2

Problem Description: 

ColdFusion 10 update 11 is suppose to support MSSQL 2012, but does not seem to support the AlwaysOn "ApplicationIntent" flag that is a big part of SQL 2012.

Steps to Reproduce: 

I should be able to add "ApplicationIntent=ReadOnly" or "ApplicationIntent=ReadWrite" to the datasource connection string and have it route to a SQL ReadOnly or ReadWrite database, but it does not. This is specifically related to the MSSQL driver provided by Adobe (Datadirect), the JDBC driver supplied by Microsoft has this functionality. This functionality is required for large scale deployments of SQL server.

Actual Result:

Expected Result:

Any Workarounds:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3630461

External Customer Info:
External Company:  
External Customer Name: Neo Rye
External Customer Email:  
External Test Config: Here is the connection string that works with the Microsoft JDBC driver:



jdbc:sqlserver://x.x.x.x:1433;databaseName=importTest;selectMethod=direct;sendStringParametersAsUnicode=false;querytimeout=1200;MaxPooledStatements=100;integratedSecurity=true;applicationIntent=ReadOnly;lastUpdateCount=false

Attachments:

Comments:

AlwaysoOn: http://technet.microsoft.com/en-us/library/ff877884.aspx ApplicationIntent=ReadOnly for JDBC driver: http://technet.microsoft.com/en-us/library/gg558121.aspx
Comment by External User
14533 | September 11, 2013 05:11:00 PM GMT
Must have functionality! I would imagine upgrading the Data Direct drivers would help with this.
14535 | September 30, 2013 03:30:48 PM GMT
Support for Microsoft SQL Server 2012 AlwaysOn support has been added to the DataDirect JDBC drivers version 5.1.1 http://www.datadirect.com/products/datadirect-connect/jdbc-drivers/features/connect-for-jdbc-release-notes-history
Comment by External User
14534 | October 02, 2013 03:32:43 PM GMT
Required to make some of the most useful parts of 2012 work with CF
14536 | February 09, 2014 09:21:37 PM GMT
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.)
Comment by Charlie Arehart
29821 | October 22, 2018 03:20:48 PM GMT