problems in connecting Access database
| From: | Mihail Bota | Date: | Mon, 26 Nov 2001 23:23:26 +0000 |
| Subject: | problems in connecting Access database | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-10612@lists.php.net to get a copy of this message | ||
Hello,
I know this may be a stupid question, but I've looked everywhere for help
and since I could not resolve the problem myself, I am asking your help.
The problem is simple: i have an Access 2000 database (Windows 2000,
IIS5.0) that
i want to query it using php4.06.
I've added the database at the ODBC driver, the path to it is okay, but
when I try to run the simple thing like:
$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
Does anybody have any idea why this thing is happening and how I can solve
the problems?
Thanks!
Mihai