Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- PHP and Access
- A.P. Madura
September 6, 2004, 7:32 am
rate this thread
I have an access database which I used to demonstrate Java - ODBC
connectivity and it works fine.
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
Database is there, DSN is defined, can access the DSN via Java but not
Anybody who knows what the problem is and what the solution to the
I am using php5.0.1
Re: PHP and Access (a newbie question)
I have ODBC set up (automatically set up for Access). ODBC driver
works fine with Java (via JDBC-ODBC bridge). The same DSN is used in
the PHP program and it doesnt work.
Any help/pointers etc is much appreciated. 2 days of searching on the
web did not yield a solution to the problem. If one does a search on
the error message, one can find many operative sites having the same
- R. Rajesh Jeba Anbiah
September 7, 2004, 11:16 am