Querying two separate connections

From: George Kuasha (gkhokie_at_hotmail.com)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 09:13:45 -0400

How would I go about writing a query or dataset linking a local Access2000
database table to an Oracle table?

I'm connected to both databases with 2 separate ADOConnections in my app.

Relevant Pages

  • Re: Access and Linked tables to Oracle
    ... You might want to consider using a Pass-through query for this, ... you do not need to update your Oracle tables through Access. ... > The initial Access database was created in Access 2000. ... > is really slow if the primary key gets created on that table ...
    (microsoft.public.access.tablesdbdesign)
  • Re: SQL Injection Legalities
    ... I am currently writing the SANS Step-by-step guide to securing Oracle ... Oracle database, application server et al to secure it. ... >This was being discussed as a legal issue in pen-test, but I was curious if>anyone else has thought of using SQL Injection to cause a DoS. ... The second OR is>only to maintain a valid SQL statement (assuming the final character in the>query will be a single quote). ...
    (Vuln-Dev)
  • Re: Limiting Large Result Sets
    ... Oracle 9i - Database ... Using query based approach, i was able to retreive all the million rows ... Fetch Size ... rows at a time from the database cursor. ...
    (comp.lang.java.programmer)
  • Re: Source of Data Files?
    ... not be willing to give you "direct" access to the database. ... You'll also need the Oracle client package installed on your local machine. ... Data> Import External Data> New Database Query ... If you send the data set to a pivot table you are not limited to ...
    (microsoft.public.excel.programming)
  • Re: Access 2002 mdb fails when used by Access 2002
    ... A multi-file query was set up under 2000 and tested good. ... connected through a link to an Oracle 9.1 database. ... remote client machines working with Access2000 and it worked fine. ...
    (comp.databases.ms-access)