Can't connect to MS Access DB...

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
sweahe
Forum Commoner
Posts: 52
Joined: Sat May 04, 2002 4:07 am
Location: Växjö, Sweden

Can't connect to MS Access DB...

Post 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!
bionicdonkey
Forum Contributor
Posts: 132
Joined: Fri Jan 31, 2003 2:28 am
Location: Sydney, Australia
Contact:

Post by bionicdonkey »

did you create a odbc data source??
sweahe
Forum Commoner
Posts: 52
Joined: Sat May 04, 2002 4:07 am
Location: Växjö, Sweden

Post by sweahe »

Yes, a system DNS pointing at the mapped networkdrive and database.
Post Reply