Re: multiple connections

Or you could try to link servers.

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"Paul Clement" <UseAdddressAtEndofMessage@xxxxxxxxxxxxxx> wrote in message
news:00jf61pncs9i339el7fdn639t1g1sfebjg@xxxxxxxxxx
> 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)


.

Relevant Pages

  • Re: Load Picture from MS Access to VB6
    ... in code to compact the database via a menu option. ... there is a chance the filename of the photo itself can ... > ¤ Well, I figured it out I think. ... loaded images into the database directly through Access (so that I could ...
    (microsoft.public.vb.general.discussion)
  • Re: Please Help Me in Visual Basic 6.0 SP6
    ... Dim dbPath As String ... Above is my programming where in this programming, ... how can i indicate myself which one i'm gonna insert to the database. ... > ¤ solution where as somebody can help me where to start. ...
    (microsoft.public.vb.database)
  • Re: Upgrading Access 97 application to dotNet
    ... I htink that you're fucked if you're going to build a database in the ... ¤ Hi. ... I am not permitted to run any form of central database server, ... Server and SQL Server Express from consideration. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Upgrading Access 97 application to dotNet
    ... I htink that you're fucked if you're going to build a database in the ... ¤ Hi. ... I am not permitted to run any form of central database server, ... Server and SQL Server Express from consideration. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Any reason why accessing Access should slowdown?
    ... On the MSACCESS / JET OLEDB front, you responded to a query I had about the ... Declared connection to Access database using string based on Jet OLDB ... Set up recordset filter in response to earlier input / selection ... ¤ I am writing a VB6 App using an Access database backend ...
    (microsoft.public.vb.database)