Combining a MS SQL / ORACLE Query

C

crispbd

I've been using ADO to connect to databases on MS SQL Server 2000 and to
Oracle databases via a linked server to deliver data to excel. Because
data requests through the linked server are placed in queue with all
user requests, this process can be incredibly slow when dealing with a
large table in Oracle. When I connect directly to the Oracle via an
oracle ADO connection things are very fast. Is there a way to make a
dual connection to both the Oracle and the SQL server dbases and query
against both together?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO - accessing oracle 3
What is the connect string between Oracle & Excel? 1
Problem wqith connection to Oracle 1
Extract data from Oracle 3
Access 2003 not linked to Oracle 11g 3
Oracle Connection String 1
Excel & MS Query caused compile errors 14
ODBC - Connecting MS Access to Oracle 10g 2

Top