|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
