note 72229 deleted from ref.mssql by cmb
| From: | cmb@php.net | Date: | Sun, 18 Aug 2019 08:33:02 +0000 |
| Subject: | note 72229 deleted from ref.mssql by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-211910@lists.php.net to get a copy of this message | ||
Note Submitter: phpnet at pginet dot com
----
This took me a while to figure out, so I may as well pass it along to save somebody time.
If you are having trouble connecting with a DSNless connection using unixodbc with freetds,
don't forget to specify the TDS_Version in your connection string.
Example (8.0 is for SQL Server 2000 exclusively):
<?php
$dsn = "DRIVER=FreeTDS;TDS_Version=8.0; TRACE=No; SERVER=someserver; PORT=someport;
DATABASE=somedb; UID=somelogin; PWD=somepassword";
?>