|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
