Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 ASP - Two Databases ??		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

basdev
Starting Member

6 Posts
Posted - 24 August 2001 :  12:03:30  Show Profile
Hello

Is it possible to open 2 different Databases from one Asp-Page?

using 2 different Connection-Strings or DSN.

cheers
Hagen

Doug G
Support Moderator

USA
6493 Posts
Posted - 25 August 2001 :  04:46:42  Show Profile
No problem.

Just use two (or more) different connection objects.


======
Doug G
======
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts
Posted - 25 August 2001 :  05:45:15  Show Profile  Visit gor's Homepage
Like this:

strConnString_1 = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/fpdb/database1.mdb") '## first database
strConnString_2 = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/fpdb/database1.mdb") '## second database

my_Conn_1.Open strConnString_1

my_Conn_2.Open strConnString_2

.......

my_Conn_1.Close
set my_Conn_1 = Nothing
my_Conn_2.Close
set my_Conn_2 = Nothing


Pierre
Join a Snitz Mailinglist
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07