| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Query Oracle syntax | Excel Discussion (Misc queries) | |||
| MS Query Oracle syntax | Excel Discussion (Misc queries) | |||
| Pivot Table, MS Query and Oracle | Excel Discussion (Misc queries) | |||
| Microsoft Query & Dates from Oracle | Excel Programming | |||
| Using MS Query to Push Data to Oracle | Excel Programming | |||
![crispbd[_25_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
