Mweb, Set your ODBCINI environment variable (and others) as per the HOWTO at www.iodbc.org. This HOWTO is for iODBC, but the concepts are the same for this error condition.
Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: mweb [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 30, 2001 12:02 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: [PHP] Problem connecting to mysql via odbc > > > 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 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
