Differences

This shows you the differences between two versions of the page.

--- v5:database:odbc [2016/01/13 01:53] – ↷ Links adapted because of a move operation mnewnham
+++ v5:database:odbc [2020/01/13 13:07] – Add tier2 tag dregad
@@ Line 51: / Line 51: @@
 [[v5:database:microsoft_sql_server#mssqlnative|SQL Server]]
 </WRAP>
-When used on Windows clients, this driver needs the Microsoft SQL server native client. There are feature limitations compared to the ''mssqlnative'' driver, use of that is always recommended.
+When used on Windows clients, this driver needs the Microsoft SQL server native client. There are feature limitations compared to the ''mssqlnative'' driver, use of that is always recommended. If you are using the driver with SQL Server versions 2012 and higher, consider using the odbc_mssql2012 driver instead, as 2012+ database specific fixes will be placed into that driver.
+------------------------------------
+===== odbc_mssql2012 =====
+<WRAP right box round 300px>
+== From ADOdb V5.21 ==
+== Specification ==
+^Driver Name|odbc_mssql2012|
+^Data Provider|odbc|
+^Status|Active((This driver is actively supported by ADOdb project members))|
+^Windows|Yes|
+^Unix|No|
+^ADOdb V5|Yes|
+^ADOdb V6|Yes|
+</WRAP>
+When used with SQL Server 2012, concatenation of strings results in a different behaviour compared with earlier versions. [[http://blog.sqlauthority.com/2013/05/12/sql-server-interesting-observation-of-concat_null_yields_null-and-concat-in-sql-server-2012-onwards/|This article]] explains the difference.
 ---------------------------
 ===== odbc_oracle =====
@@ Line 106: / Line 120: @@
 ===== Feature Limitations =====
 ODBC connections have functionality limitations include transactional handling. See the [[v5:database:feature_comparison|Feature Matrix]] for more information
-{{tag>[odbc windows active supported]}}
+{{tag>[odbc windows active supported tier2]}}