ASP: How do I connect to an Access DB on another server?

[andy.m...@siemens.com]

Hi Gang

I have IIS5 running on a Win 2000 server that hosts our asp
applications. I'm creating a new application on this server but it
needs to access an Access database on another Win 2003 server. In the
asp how do I connect to the database on the remote server? Please
help.

Andy

[Jeff Cochran]

This is an ASP issue (technically a networking issue) not an IIS one.
Had you asked in the asp.db group they probably would have referred
you to:

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMicrosoftJet

Jeff

[Kristofer Gafvert]

Hi,

You need access to the file system of the remote server, so you could
probably use an UNC path to access the file.

This KB Article explains more:

"How to connect to a remote Access database from Active Server Pages"
http://support.microsoft.com/kb/253580

--
Regards,
Kristofer Gafvert
www.gafvert.info - My Articles and help
www.ilopia.com