Linking multiple web servers to a single DB


I am working with 3 different web servers (personal web server, intranet web server, and internet web server) and I have duplicate copies of an ACCESS database on each server.  What I would like to do is direct all database connection to a single database that resides on one of the server.  

Currently I am using IIS 3 with SP3, ASP, FrontPage Extension, and Visual InterDev as the design tool.  I would like to find a way to connect all the web server to a remote ACCESS database.

Here is the code that I am using to establish connection to a database on each server:

Set formpubsDSN = Server.CreateObject("ADODB.Connection")
formpubsDSN.ConnectionTimeout = 15
formpubsDSN.CommandTimeout = 30
formpubsDSN.Open "DBQ=C:\InetPub\wwwroot\usbccae2\data\database\formpubs.mdb;DefaultDir=C:\InetPub\wwwroot\usbccae2\data\database;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;;User Id=admin;", "", ""
Set cmdTemp = Server.CreateObject("ADODB.Command")
Set rs = Server.CreateObject("ADODB.Recordset")
cmdTemp.CommandText = "SELECT * FROM *"
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = formpubsDSN
rs.Open cmdTemp, , 1,3

Please suggest a way for me to code the connection string to access a remote Microsoft Access Database or suggest any method of unifying the database.

Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

sybeConnect With a Mentor Commented:
The database should be on a "mapped" drive.
- Share the directory where the database is
- Map the shared directory in the other servers, it will probably appear like drive E or F or whatever.
- on each server, use the correct path to the database from that machine.

This is the only solution using Access. The biggest disadvantage is that mapped drives are specific for each user that is allowed to login on the machine. Logging out will make them not active.

So if you want a real good solution, you'll have to use a database server (like MS SQL or Oracle)

rick101396Author Commented:

thanks for the help
All Courses

From novice to tech pro — start learning today.