RE: [PHP] Problem connecting to mysql via odbc
| From: | Andrew Hill | Date: | Fri, 30 Nov 2001 14:51:32 +0000 |
| Subject: | RE: [PHP] Problem connecting to mysql via odbc | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-76207@lists.php.net to get a copy of this message | ||
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:mweb@inwind.it]
> Sent: Friday, November 30, 2001 12:02 AM
> To: php-general@lists.php.net; mysql@lists.mysql.com
> 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: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
>