ODBC and PEAR DB
| From: | Schlegel, Harold | Date: | Mon, 08 Sep 2003 19:50:03 +0000 |
| Subject: | ODBC and PEAR DB | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-7653@lists.php.net to get a copy of this message | ||
I don't seem to be able to make a valid DSN for an ODBC data source.
I have an ODBC data source named: ASA7Sample.
Using DB::connect, I have tried
DB::connect("odbc:///ASA7Sample")
DB::connect("odbc://user:password/ASA7Sample")
DB::connect("odbc://user:password@localhost/ASA7Sample")
DB::connect("odbc://localhost/ASA7Sample")
and several other permutations and all I get is "DB Error: connect failed"
Is there some special rules govering ODBC?
I've tried a connect to MySQL using connect("mysql://use:password@localhost/test")
and that connects fine, so I know the pear db is working.
H Schlegel ( : - | )