Solved

Linking multiple web servers to a single DB

Posted on 1998-10-22
2
182 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Report: Liquid Web beats Amazon, Rackspace & More

A study by performance analyst firm Cloud Spectator finds that Liquid Web beats rivals Amazon, Rackspace and DigitalOcean when it comes to website and cloud application performance.

Question has a verified solution.

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

An enjoyable and seamless user experience can go a long way on an eCommerce site. While a cohesive layout and engaging copy play roles in creating a positive user experience, some sites neglect aspects that seem marginal but in actuality prove very …
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
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:
The viewer will learn how to count occurrences of each item in an array.

738 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