Page 1 of 1

Can't connect to MS Access DB...

Posted: Fri Mar 14, 2003 9:43 am
by sweahe
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!

Posted: Fri Mar 14, 2003 3:19 pm
by bionicdonkey
did you create a odbc data source??

Posted: Sat Mar 15, 2003 12:01 am
by sweahe
Yes, a system DNS pointing at the mapped networkdrive and database.