RE: [PHP] Problem connecting to mysql via odbc

[Andrew Hill]

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]

[PHP] Problem connecting to mysql via odbc

[mweb]

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]