Solved

Linking multiple web servers to a single DB

Posted on 1998-10-22
2
173 Views
Last Modified: 2013-12-25
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.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.

0
Comment
Question by:rick101396
2 Comments
 
LVL 28

Accepted Solution

by:
sybe earned 200 total points
ID: 1855932
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)

0
 

Author Comment

by:rick101396
ID: 1855933
sybe

thanks for the help
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Envision that you are chipping away at another e-business site with a team of pundit developers and designers. Everything seems, by all accounts, to be going easily.
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now