note 72229 added to ref.mssql

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): $dsn = "DRIVER=FreeTDS;TDS_Version=8.0; TRACE=No; SERVER=someserver; PORT=someport; DATABASE=somedb; UID=somelogin; PWD=somepassword"; ---- Server IP: 66.163.161.117 Probable Submitter: 64.183.76.234 ---- Manual Page -- http://www.php.net/manual/en/ref.mssql.php Edit -- https://master.php.net/note/edit/72229 Del: integrated -- https://master.php.net/note/delete/72229/integrated Del: useless -- https://master.php.net/note/delete/72229/useless Del: bad code -- https://master.php.net/note/delete/72229/bad+code Del: spam -- https://master.php.net/note/delete/72229/spam Del: non-english -- https://master.php.net/note/delete/72229/non-english Del: in docs -- https://master.php.net/note/delete/72229/in+docs Del: other reasons-- https://master.php.net/note/delete/72229 Reject -- https://master.php.net/note/reject/72229 Search -- https://master.php.net/manage/user-notes.php