Re: multiple connections
- From: Paul Clement <UseAdddressAtEndofMessage@xxxxxxxxxxxxxx>
- Date: Thu, 21 Apr 2005 11:05:06 -0500
On Thu, 21 Apr 2005 06:56:05 -0700, "Kate" <Kate@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
¤ Yes, both are Oracle databases, but they are not on the same server.
¤ I thought the problem was the 'set rs = db2Conn.Execute(...)' statement. It
¤ only connects to db2. Perhaps that's why the recordset couldn't connect to
¤ db1? I thought there might be syntax that sets a recordset to more than one
¤ database?
¤
¤ "Val Mazur (MVP)" wrote:
¤
¤ > Hi Kate,
¤ >
¤ > You cannot use connection against one database to execute any SQL statements
¤ > against another database. You connection is limited in this case. I am not
¤ > sure about Oracle, but in a case of SQL Server when two databases reside on
¤ > a same server you could execute SQL statements against different database
¤ > specifying full qualified name to the databases, like
¤ >
¤ > insert into Databasename1.dbo.TableName (select * from
¤ > Databasename2.dbo.TableName where name='abc')"
¤ >
¤ > Could be that Oracle supports similar or same syntax
I don't have a scenario at the moment to test this syntax, but you might to connect to the
destination database and then try the following:
INSERT INTO [SCHEMA.DESTABLE] SELECT * FROM [SCHEMA.SRCTABLE] IN '' [ODBC;Driver={Microsoft ODBC For
Oracle};Server=ServerName;Uid=userID;Pwd=password;]"
Paul
~~~~
Microsoft MVP (Visual Basic)
.
- Follow-Ups:
- Re: multiple connections
- From: Val Mazur \(MVP\)
- Re: multiple connections
- References:
- multiple connections
- From: Kate
- Re: multiple connections
- From: Val Mazur \(MVP\)
- Re: multiple connections
- From: Kate
- multiple connections
- Prev by Date: Re: I am dead with ado rs.Find("Code Like 'E*')
- Next by Date: connection pooling
- Previous by thread: Re: multiple connections
- Next by thread: Re: multiple connections
- Index(es):
Relevant Pages
|
