469,621 Members | 1,678 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,621 developers. It's quick & easy.

PHP and Access

Need help in debugging this problem.

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
Connection Failed:

Database is there, DSN is defined, can access the DSN via Java but not
with PHP.

Anybody who knows what the problem is and what the solution to the
problem is.

I am using php5.0.1

Thanks
Jul 17 '05 #1
2 4962
Just to clarify the situation (with reference to my original mail).

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
problem.

Thanks

Ajith
Jul 17 '05 #2
aj********@yahoo.com (A.P. Madura) wrote in message news:<47**************************@posting.google. com>...
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:

<snip>

Manual and the usernotes are your close friends <http://in2.php.net/odbc_connect>

--
| Just another PHP saint |
Email: rrjanbiah-at-Y!com
Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

63 posts views Thread by Jerome | last post: by
13 posts views Thread by Simon Bailey | last post: by
reply views Thread by Frederick Noronha \(FN\) | last post: by
64 posts views Thread by John | last post: by
17 posts views Thread by Mell via AccessMonster.com | last post: by
37 posts views Thread by jasmith | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.