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/07/08 01:24] – mnewnham | v5:database:microsoft_sql_server [2020/01/13 12:38] – Add tier1 tag dregad | ||
---|---|---|---|
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 ==== | ==== 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 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. | 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. | ||
Line 12: | Line 12: | ||
More about the FreeTDS libraries [[http:// | More about the FreeTDS libraries [[http:// | ||
- | ==== SQL Server 2003 ==== | + | |
- | Connecting to SQL server 2003 creates a difficulty There is no support for native client connections, | + | |
- | ------------------------------------ | + | |
====== mssqlnative ====== | ====== mssqlnative ====== | ||
<WRAP right box round 300px> | <WRAP right box round 300px> | ||
Line 116: | Line 114: | ||
This driver provides access to Microsoft SQL Server databases from unix systems via Freetds | This driver provides access to Microsoft SQL Server databases from unix systems via Freetds | ||
- | {{tag> | + | {{tag> |
-------------------------------------- | -------------------------------------- | ||
===== mssql (Windows) ===== | ===== mssql (Windows) ===== |
v5/database/microsoft_sql_server.txt · Last modified: 2022/11/15 02:13 by mnewnham