Can't connect to MS Access DB...
Posted: Fri Mar 14, 2003 9:43 am
Someone here who knows how to connect to an MS Access database that is located on a different server on my companys internal network?
It works perfectly when the .mdb file is located on the same server as where I run Apache/PHP... I have mapped a drive X:\\ to this other server and tried to access it through ODBC System DNS but I get this warning message from PHP:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides., SQL state S1009 in SQLConnect in c:\httpdocs\www\odbc.php on line 5
Help please!
It works perfectly when the .mdb file is located on the same server as where I run Apache/PHP... I have mapped a drive X:\\ to this other server and tried to access it through ODBC System DNS but I get this warning message from PHP:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides., SQL state S1009 in SQLConnect in c:\httpdocs\www\odbc.php on line 5
Help please!