Problem connecting to mysql via odbc
| From: | mweb | Date: | Fri, 30 Nov 2001 05:02:01 +0000 |
| Subject: | Problem connecting to mysql via odbc | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-76141@lists.php.net to get a copy of this message | ||
Hello,
I have a page whoch should connect to a mysql database via odbc,
on a RH 7.2 PC with the relevant rpm listed below.
I know what to do when the db is reachable, but can't start:
the instruction:
$conn=odbc_connect("db9,"","");
just yelds this result:
Warning: SQL error: [unixODBC][Driver Manager]Data source name not found, and
no default driver specified, SQL state IM002 in SQLConnect in one.php on line
20
Warning: Supplied argument is not a valid ODBC-Link resource in one.php on
line 22
THis is certainly something wrong with my odbc setup, but can't figure it
out. I saw a thread couple of days ago about myodbc dsn creation, but can't
relate it to my problem. Actually, I only have odbcinst, not the commands
mentioned in that message.
Any help is appreciated!
Thanks,
mweb
RPM list
php-ldap-4.0.6-7
unixODBC-devel-2.0.7-3
mod_auth_mysql-1.11-1
mysqlclient9-3.23.22-6
php-mysql-4.0.6-7
unixODBC-2.0.7-3
asp2php-0.75.17-1
php-imap-4.0.6-7
php-pgsql-4.0.6-7
mysql-3.23.41-1
MyODBC-2.50.37-2
mysql-server-3.23.41-1
php-manual-4.0.6-7
php-odbc-4.0.6-7
libodbc++-0.2.2pre4-12
php-4.0.6-7
mysql-devel-3.23.41-1
perl-DBD-MySQL-1.2216-4