[freetds] basic install OK but can't get PHP to work

kenn kenn at printussery.com
Thu Jul 27 09:11:55 EDT 2006


Greetings.

I'm attempting to install freetds on my Debian 3.1 (sarge).  Using
apt-get, I've installed freetds and configured freetds.conf with:

[psi]
        host = 192.168.100.17
        tds version = 7.0

I can connect using sqsh, so I think I'm okay so far.

Then I installed php4-odbc but have not been successful connecting via
PHP4. When I run the following code:

print_r("we are trying to connect");
$connect = odbc_connect("psi", "sa", "cibsigcib") or die ("couldn't
connect");

print_r($connected);


I get the following error:

we are trying to connect
Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data
source name not found, and no default driver specified, SQL state IM002
in SQLConnect in /var/www/eve/index.php on line 6
couldn't connect


What am I doing wrong?

Any and all help appreciate.

Kenn




More information about the FreeTDS mailing list