Re: multiple connections

On Tue, 19 Apr 2005 23:24:05 -0700, "Kate" <Kate@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

¤ 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!
¤
¤

I don't believe you can use that syntax. Are these both Oracle databases?


Paul
~~~~
Microsoft MVP (Visual Basic)
.

Relevant Pages

  • Re: Managing connections to attached tables
    ... ¤ against attached tables? ... Managing connections to those attached tables? ... We have REPLACED legacy MDB TABLES by "upsizing" to SQL Server. ... tables with identical names to SQL Server are linked to the MDB ...
    (microsoft.public.vb.database.dao)
  • Re: Multiple DSN-less connections
    ... ¤ connections. ... BTW-Frontpage is also accessing the file with DSN-less connections. ... I'm not sure what you mean by "lockout issues" unless you're referring to someone opening the ...
    (microsoft.public.vb.database.ado)
  • Re: how to verify the amount of live connections to an Acces database ?
    ... ¤ who are working with the database? ... I want to verify the amount of ... wrong calculation of the amount of connections. ...
    (microsoft.public.vb.database)
  • Re: How to access a Remote Database through VB6?
    ... ¤ I wanted to access a remote database in my VB application. ... Is there any other way to access a Remote Database through HTTP? ... Microsoft MVP ...
    (microsoft.public.vb.database.ado)
Loading