v5:database:microsoft_sql_server
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
v5:database:microsoft_sql_server [2018/03/13 19:52] – [Using Windows Authentication] mnewnham | v5:database:microsoft_sql_server [2018/07/08 01:07] – [mssql] mnewnham | ||
---|---|---|---|
Line 2: | Line 2: | ||
~~NOTOC~~ | ~~NOTOC~~ | ||
===== Description ===== | ===== Description ===== | ||
- | 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 | ||
+ | This driver, which runs on both Windows and Linux clients, | ||
+ | |||
+ | More about the Microsoft SQL Server client for Linux [[https:// | ||
+ | |||
+ | ==== mssql==== | ||
+ | This allows connections from Unix based clients using the freetds libraries. | ||
+ | |||
+ | More about the FreeTDS libraries [[http:// | ||
==== SQL Server 2003 ==== | ==== SQL Server 2003 ==== | ||
Connecting to SQL server 2003 creates a difficulty There is no support for native client connections, | Connecting to SQL server 2003 creates a difficulty There is no support for native client connections, | ||
Line 13: | 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 21: | Line 30: | ||
</ | </ | ||
- | **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 |
- | 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 |
+ | * On Windows clients, | ||
+ | * 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