multiple connections
- From: "Kate" <Kate@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 19 Apr 2005 23:24:05 -0700
I have 2 connections to 2 databases (db1, db2)
The connections are fine. But when I tried to do the following statement, I
got an error:
Public db1Conn As ADODB.Connection
Public db2Conn As ADODB.Connection
Public rs As ADODB.Recordset
Set rs = db2Conn.Execute("insert into tableA@db2 (select * from tableA@db1
where name='abc')")
The error is 'ora-02019: connection description for remote database not
found.'
I think it's because when I Set rs = db2Conn.Execute... it only connects to
db2 not db1. How to fix this problem? Thanks!
.
- Follow-Ups:
- Re: multiple connections
- From: Val Mazur \(MVP\)
- Re: multiple connections
- From: Paul Clement
- Re: multiple connections
- Prev by Date: Re: Problem with find method
- Next by Date: Re: Newbie Question - Can rs.Find work for two fields
- Previous by thread: export data from recordset to excel
- Next by thread: Re: multiple connections
- Index(es):
Relevant Pages
|
