[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