RE: [PHP-DB] problems in connecting Access database
| From: | Andrew Hill | Date: | Tue, 27 Nov 2001 14:05:57 +0000 |
| Subject: | RE: [PHP-DB] problems in connecting Access database | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-14589@lists.php.net to get a copy of this message | ||
Mihail,
> >$conn = odbc_connect( 'test' , ' ', ' ' );
> >
> >where test is the name of that database, then the output is smth. like
> >
> >Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not
> >found and no default driver specified, SQL state IM002 in SQLConnect in
> >c:\inetpub\wwwroot\test.php on line 11
Miles is correct with regards to using a System DSN.
Other things that can cause that error include mispelling the DSN name, etc.
but you don't appear to be using a DSN yet.
Create one in the ODBC Administrator (the ODBC Driver Manager) using the MS
Driver for Access and you should be all set.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers