Solved

Linking multiple web servers to a single DB

Posted on 1998-10-22
2
179 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
Any business that wants to seriously grow needs to keep the needs and desires of an international audience of their websites in mind. Making a website friendly to international users isn’t prohibitively expensive and can provide an incredible return…
This video teaches users how to migrate an existing Wordpress website to a new domain.
The viewer will learn how to count occurrences of each item in an array.

679 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