Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: DSNLess Connection to Remote MS-Access DB


Message #1 by "Eric Levine" <eric@d...> on Thu, 10 Oct 2002 15:15:07 -0400
Good afternoon to all,

Quick question.. I am in the process of creating an application that
will go across multiple web servers.  Can someone please help me with
the code necessary to connect to an Access DB that is located on one
server, from ASP code on another.

I understand that HTTP is not acceptable in the connection string so I
am a bit stumped on how to recognize the .mdb file on the remote server.

Example:

Server 1 - Connection String
  objSConn.Open "Provider = Microsoft.Jet.OLEDB.4.0; " & _
   		    "Data Source = http://www.dbstore.com/data/test.mdb"


Server 2 - .mdb File on server www.dbstore.com
	c:\data\test.mdb

Many thanks in advance.

Regards,
Eric


  Return to Index