Combining a MS SQL / ORACLE Query
 

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?


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=276612

Combining a MS SQL / ORACLE Query
 

google on sqlserver passthrough oracle..





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


crispbd wrote :


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?