Solved

Linking multiple web servers to a single DB

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

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…
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

808 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