Problems with ODBC connectivity with PHP 4.2.3

[wbhk]

I have developed a PHP application that accesses a Microsoft Access database through ODBC. The application works well using PHP version 4.1. I have recently installed the newest version of PHP (4.2.3) on another machine running NT4, and IIS 4.
While the new version of PHP module is running fine, I cannot retrieve records from the database. After a little testing, it is clear that the ODBC_CONNECT function is failing to link up with my ODBC source. Again, I have made the same settings in the new ODBC entry as is present on the development machine (same source name, login, and password). Could there be a version problem with the PHP module? Any other suggestions would be greatly appreciated.

Thanks, Bill

[barand]

Is your Access database on the same PC as your IIS server?

I've not tried it with IIS yet but when using PWS it seems impossible to connect to an access database on another PC on the network, even after editing the registry to give the full UNC path for the ODBC connection.