rick101396
asked on
Linking multiple web servers to a single DB
Hi
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 .Connectio n")
formpubsDSN.ConnectionTime out = 15
formpubsDSN.CommandTimeout = 30
formpubsDSN.Open "DBQ=C:\InetPub\wwwroot\us bccae2\dat a\database \formpubs. mdb;Defaul tDir=C:\In etPub\wwwr oot\usbcca e2\data\da tabase;Dri ver={Micro soft Access Driver (*.mdb)};DriverId=25;FIL=M S Access;ImplicitCommitSync= Yes;MaxBuf ferSize=51 2;MaxScanR ows=8;Page Timeout=5; SafeTransa ctions=0;T hreads=3;U ID=admin;U serCommitS ync=Yes;;U ser 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.
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
formpubsDSN.ConnectionTime
formpubsDSN.CommandTimeout
formpubsDSN.Open "DBQ=C:\InetPub\wwwroot\us
Set cmdTemp = Server.CreateObject("ADODB
Set rs = Server.CreateObject("ADODB
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for the help