Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How Do I Connect to 2 Access DBs on the Same Web Server?

Status
Not open for further replies.

HLotis

Programmer
Dec 14, 1998
31
US
How Do I Connect to 2 Access DBs on the Same Web Server?<br>
<br>
I have two databases with the same database name but in different folders on the same NTServer. How can the Administrator make a connection to the second one in folder FY2000? The first is in a folder FY99. I would rather not change the name of the database.<br>
<br>
On my personal web server, the GlobalAsa file pointed the way. I am getting a err 501.
 
Make an ODBC connection (each with a different name) or two connections in interdev, with the correct connection strings.
 
The problem was that the database was in a second folder and was not checked off as a part of a Virtual web and was not updatable by the browser. Even tho it had all rights.<br>
<br>
Once &quot;use Alias&quot; was checked off, then the FULL PATH NAME could be used. The enabling of Alias allowed the folder to become a part of the Virtual Web. When less then the full path was used, it assumed the old folder thus getting 501, not allowed to access a non virtual folder.<br>
<br>
Since only one would be chosen to be userd, the same DSN could be used.<br>

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top