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!
Can't connect to MS Access DB...
Moderator: General Moderators
-
bionicdonkey
- Forum Contributor
- Posts: 132
- Joined: Fri Jan 31, 2003 2:28 am
- Location: Sydney, Australia
- Contact: