Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- A.P. Madura
September 7, 2004, 6:20 am
rate this thread
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
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