ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:database:microsoft_sql_server

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:microsoft_sql_server [2018/07/08 01:02] – [Description] mnewnhamv5:database:microsoft_sql_server [2018/07/08 01:08] – [mssqlnative] mnewnham
Line 4: Line 4:
 There are 2 supported drivers that allow connections to Microsoft SQL Server databases.  There are 2 supported drivers that allow connections to Microsoft SQL Server databases. 
 ==== mssqlnative ==== ==== mssqlnative ====
-This driver, which runs on both Windows and Linux clients, allows connections to Microsoft SQL Server databases versions 2008 and up, and uses the Microsoft Native Client libraries. This driver is now recommended for both Windows and Linux platforms, and provides the fastest PHP connection.+This driver, which runs on both Windows and Linux clients, allows connections to Microsoft SQL Server databases versions 2008 and up, and uses the Microsoft Native Client libraries. This driver is recommended for Windows Clients running PHP 5.3 and higher, and Linux Clients running PHP 7.0 and higher, and provides the fastest PHP connection.
  
 More about the Microsoft SQL Server client for Linux [[https://github.com/Microsoft/msphpsql|here]] More about the Microsoft SQL Server client for Linux [[https://github.com/Microsoft/msphpsql|here]]
  
 ==== mssql==== ==== mssql====
-This allows connections from Unix based clients using the freetds libraries.+This allows connections from Unix based clients using the freetds libraries. It can be used with version 5.x of PHP
  
 More about the FreeTDS libraries [[http://www.freetds.org/|here]] More about the FreeTDS libraries [[http://www.freetds.org/|here]]
Line 22: Line 22:
 ^Status|Active((This driver is actively supported by ADOdb project members))| ^Status|Active((This driver is actively supported by ADOdb project members))|
 ^Windows|Yes| ^Windows|Yes|
-^Unix|No|+^Unix|Yes|
 ^ADOdb V5|Yes| ^ADOdb V5|Yes|
 ^ADOdb V6|Yes| ^ADOdb V6|Yes|
Line 30: Line 30:
 </WRAP> </WRAP>
  
-**This is the preferred driver for connecting to a SQL server database from Windows clients.**+**This is the preferred driver for connecting to a SQL server database from both Windows and Linux clients.**
  
-This driver was contributed by Microsoft and provides connections to SQL server databases greater than SQL Server 2003. It requires PHP version 5.3 or greater, Microsoft native client software and the appropriate PHP driver. +The original driver was contributed by Microsoft and provides connections to SQL server databases greater than SQL Server 2003.  
 +  * On Windows clients, It requires PHP version 5.3 or greater, Microsoft native client software and the appropriate PHP driver.  
 +  * On Linux clients, PHP version 7.0 and higher is required.
  
 Sequences are supported in native mode in SQL Sever 2012, and emulated in earlier versions.  Sequences are supported in native mode in SQL Sever 2012, and emulated in earlier versions. 
v5/database/microsoft_sql_server.txt · Last modified: 2022/11/15 02:13 by mnewnham