Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-01 : 08:48:45
|
| Eric writes "I have a database on an instance of SQL Server 2000 in which I need to update from an Oracle 8i database instance. The Oracle 8i database is across a VPN and joining tables between the two is extremely slow. So, I figured out how to use the OPENQUERY function in SQL Server 2000 for passing a query to ORACLE and return a result set. The problem is OPENQUERY does not take variables for its parameters. I need to be able to create a query on the fly (from stored proc or from an app) to send as a pass-through to the ORACLE database so I can process the results into my SQL database. Is there another function provided by Microsoft to do this, or could I set up something different between the two to speed things up?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
Pass-Through query from SQL Server 2000 to Oracle 8i 