Simple connection between PHP and Access (Help needed)

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Need help in debugging this problem.

I have an access database which I use to demonstrate Java - ODBC
connectivity and it works perfectly fine. This allows me to assume
that the Data Source name definition is OK.

I tried to access the same DSN (system DSN) thro' PHP and the
following error is displayed.

Warning: odbc_connect() [function.odbc-connect]: SQL error:
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified, SQL state IM002 in SQLConnect in
D:\Ajith\Teaching\PHP\Examples\php\dbmstest.php on line 8
Connection Failed:

In summary: Database is there, DSN is defined, can access the DSN via
Java but not with PHP (or ASP).

Anybody who knows what the problem and the solution is?

I am using php5.0.1


Site Timeline