Simple connection between PHP and Access (Help needed)

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • A.P. Madura

    Simple connection between PHP and Access (Help needed)

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

    Thanks
Working...