Hello all.
My head hurts from hitting it on my desk all day, so I thought I'd turn to a fresher set of eyes. The issue I'm having is getting PHP to connect ODBC. I can get it to work using isql from the command line. Can you verify my settings....:
/etc/odbc.ini:
[MySQL]
Description = MySQL 3.51 ODBC driver
Driver = MySQL
Host = s-irv-web02
Server = s-irv-web02
UID = user
Password = pass
Database = clients
Port = 3306
/etc/odbcinst.ini:
[MySQL]
Description = ODBC 3.51 for MySQL
Driver = /usr/lib/libmyodbc3.so
Setup = /usr/lib/libodbcmyS.so
FileUsage = 1
UsageCount = 2
Again, isql allows me to connect with the same settings as above: isql MySQL user pass
I've tried several settings in PHP to attempt to connect to it. All have been fruitless:
<?php
$user = 'user';
$pass = 'pass';
$dsn = "Driver={MySQL};Server=s-irv-web02;Host=s-irv-web02;";
$dsn = "Driver={MySQL 3.51 ODBC driver};Server=s-irv-web02;Host=s-irv-web02;";
$dsn = "Driver={MySQL};Server=s-irv-web02;Host=s-irv-web02;User=$user;Password=$pass";
odbc_connect ($dsn, $user, $pass);
?>
I've tried the above DSNs and many other versions of it ad nauseum. The specific error I'm getting is... "[unixODBC][Driver Manager]Data source name not found, and no default driver specified." I really have searched high and low for a solution, but to no avail. Any thoughts?
Thanks in advance,
~Philip
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
