无法使用odbc和freetds从php连接到MSSQL 2008 db

Question

I have been searching everywhere for solutions, but am getting more and more confused.

I am trying to connect to a SQL Server 2008 db from php using FreeTDS. The server is a MediaTemple DV 4.0 and it is running CentOS 5.7. I have a version of FreeTDS (v0.91) installed that I think I might have compiled several months back. When I run tsql -C it says my freetds.conf is in /usr/local/etc and a TDS version 5.0. I need it to be TDS version 7.0, but when I change that conf file, it does not change. And I can't find the conf file it is using. (problem 1)

I can connect to my db using tsql -H -p -U and run a query. However in my php file, I get IM002 error which I believe is a connection error to the db. I use odbc_connect for that. (problem 2, the biggest problem)

I don't even know where to start, as I have been installing, uninstalling for about the last 2 months...

I would welcome any suggestion on how to resolve the issue. As a side note, it used to work before I upgraded my DV at MediaTemple.

Thanks! Shawn

Here is my tsql -C

Compile-time settings (established with the "configure" script) Version: freetds v0.91 freetds.conf directory: /usr/local/etc MS db-lib source compatibility: no Sybase binary compatibility: no Thread safety: yes iconv library: yes TDS version: 5.0 iODBC: no unixodbc: yes SSPI "trusted" logins: no Kerberos: no

Answer 1

SQL Server 2008 actually wants TDS Version 7.3 -- not 7.0, which corresponds to SQL Server 7.

I can't provide assistance with FreeTDS debugging, but you might try a commercial driver where there's some incentive to fix problems, like my employer's offering. It's free to test for 2 weeks.

We also provide some docs on using PHP with ODBC, on the iODBC.org site.