|
|
|
|
|
| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Connecting two different databases! |
|
From: |
Craig Waterman |
|
Date: |
6/30/2000 9:50:49 AM |
|
IP: |
24.92.230.198 |
You can create 2 connection objects and connect recordsets to different ones... i.e.
dim oConn1, oConn2, rs1, rs2
set oConn1 = Server.CreateObject("ADODB.Connection")
set oConn2 = Server.CreateObject("ADODB.Connection")
set rs1 = Server.CreateObject("ADODB.Recordset")
set rs2 = Server.CreateObject("ADODB.Recordset")
oConn1.Open [Connection info for db1]
oConn2.Open [Connection info for db2]
rs1.Open "someSQL", oConn1
rs2.Open "someSQL", oConn2
Just remember: TIMTOWTDI Theres more than one way to do it.
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
