FreeTDS Development Group

[Jochen Daum <jd AT automatem.co.nz>]

Hi James,

ok great to hear this was found.

My isql problem is now resolved as well - I was missing the
"Description" keyword in odbc.ini

I'm still stuck with pdo_odbc though.

This connection string seems correct to me:

odbc:Driver=Freshco;Server=192.168.10.153;Port=1433;Database=ExportInformationSystem;UID=sa;PWD=pass

because Freshco is my DSN. It returns: SQLSTATE[IM002]
SQLDriverConnect: 0 [unixODBC][Driver Manager]Data source name not
found, and no default driver specified
I have restarted Apache, just in case.

When I try the driver name from odbcinst.ini

odbc:Driver=FreeTDS;Server=192.168.10.153;Port=1433;Database=ExportInformationSystem;UID=sa;PWD=pass

I get: SQLSTATE[08S01] SQLDriverConnect: 20009 [unixODBC][FreeTDS][SQL
Server]Unable to connect: Adaptive Server is unavailable or does not
exist

jochen@autolaptop4:~$ cat /etc/odbc.ini
[Freshco]
Driver=FreeTDS
Description=Local VM for Freshco
ServerName=192.168.10.153
Database=ExportInformationSystem
Port=1433
tds_version=7.1
jochen@autolaptop4:~$ cat /etc/odbcinst.ini
[FreeTDS]
Description = FreeTDS
Driver = /usr/local/lib/libtdsodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so
Trace = Yes
TraceFile = /tmp/freetds.log
FileUsage = 1
UsageCount = 1


Thanks for any further pointers.

Jochen