ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:database:odbc

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
v5:database:odbc [2016/01/31 18:34] – [odbc_mssql] mnewnhamv5:database:odbc [2016/01/31 19:31] mnewnham
Line 51: Line 51:
 [[v5:database:microsoft_sql_server#mssqlnative|SQL Server]] [[v5:database:microsoft_sql_server#mssqlnative|SQL Server]]
 </WRAP> </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. 
-==== Use With SQL Server 2012 ====+------------------------------------ 
 +===== 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. 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.
 --------------------------- ---------------------------
v5/database/odbc.txt · Last modified: 2021/01/11 09:59 by peterdd