Take the 2-minute tour ×  I have installed freetds with unixODBC
and when I test the connection with isql it works perfectly but
when I try to make the connection with php I get an S1000 error.
my configuration details are I have a DSN in my freetds.conf
host = port = 1433 tds version = 8.0 client charset = UTF-8  My
odbc.ini file has  Driver = FreeTDS Descrioption = conn unixodbc
with FreeTDS tds version = 8.0 Server = Port = 1433 Database =
mydb client charset = UTF-8  my odbcinst file has  Description =
MSSQL Driver Driver = /usr/lib64/libtdsodbc.so UsageCount = 1  I
used this tutorial to make the installation and I installed the
drivers with odbcinst.  In order to connect with php I use the
DSN connection and I tried with both odbc_connect and
mssql_connect.   mssql_pconnect(
"MYDSN",$this->user,$this->password)  i also tried with PDO with
the following code  new \PDO
("dblib:host=MYDSN;dbname=mydb;",$this->user,$this->password);
With isql everything worked fine.  I am using Microsoft SQL
Server 2008.