v5:database:microsoft_sql_server
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:database:microsoft_sql_server [2019/12/29 20:21] – [Description] mnewnham | v5:database:microsoft_sql_server [2022/11/15 02:13] (current) – [Common Connection Problems] mnewnham | ||
---|---|---|---|
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 28: | Line 26: | ||
[[v5: | [[v5: | ||
[[v5: | [[v5: | ||
+ | == See Also == | ||
+ | [[v5: | ||
</ | </ | ||
Line 74: | Line 74: | ||
$db-> | $db-> | ||
</ | </ | ||
+ | |||
+ | ===== Common Connection Problems ===== | ||
+ | Recent versions of SQL Server fail to connect with an error '' | ||
+ | |||
+ | This problem can be resolved by adding | ||
+ | |||
+ | <code php> | ||
+ | $db-> | ||
+ | </ | ||
+ | |||
+ | before issuing the '' | ||
+ | |||
+ | |||
------------------------------ | ------------------------------ | ||
===== How to create a connection under Linux ===== | ===== How to create a connection under Linux ===== | ||
Line 116: | Line 129: | ||
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.1577647269.txt.gz · Last modified: 2019/12/29 20:21 by mnewnham