[unixODBC-support] Error in PHP mode: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source, SQL state S1000
nick.gorham at easysoft.com
Mon Feb 2 18:43:47 GMT 2009
Gérard Maulino wrote:
> Hi there,
> I'm trying to get Freetds + unixODBC working on a Linux FC 6 and it
> works in command line but not in Apache/PHP.
> I've checked that the line "extension=odbc.so" is there in the
> /etc/php.d/odbc.ini file and that my configuration file (freetds.conf,
> odbc.ini & odbcinst.ini) are correct but I can't find something wrong.
> I've installed unixODBC v 2.2.14 and FreeTDS driver version 0.82 .
> I can query the remote database using isql. That makes me wonder if I
> need to re-compile or change something in my PHP configuration.
> Any help would be great.
> Thanks in advance.
I would guess its a issue with freetds reading the config files, from
the error php is finding odbc.so, thats finding unixODBC, and thats
loading the freeTDS driver.
More information about the unixODBC-support