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?