PHP and Access

[A.P. Madura]

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\Teachi ng\PHP\Examples \php\dbmstest.p hp 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

[A.P. Madura]

Re: PHP and Access (a newbie question)

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

[R. Rajesh Jeba Anbiah]

Re: PHP and Access

ajitolanka@yaho o.com (A.P. Madura) wrote in message news:<47e67747. 0409060132.1c82 fbab@posting.go ogle.com>...[color=blue]
> 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\Teachi ng\PHP\Examples \php\dbmstest.p hp on line 8
> Connection Failed:[/color]
<snip>

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

--
| Just another PHP saint |
Email: rrjanbiah-at-Y!com