I normally would, but this application has a lot of code and this one issues was not identified by the users prior to going into production. A recompile and re-test...

MS SQL Server ODBC 2.5.

Thanks!

Thanks for everyone's help!! After my testing last week, I was pretty sure I'd need an sp or a user-defined function to do this. I will start my next round...

1. Start creating a new linked server.

2. Select the OLEDB provider.

3. Click the OLEDB Provider Options button.

4. You do not have to complete the linked server for the options to...

Thanks for the suggestion. I've found the solution though:

When a new linked server is created, the Oracle OLEDB driver options can be set. Once the option "Nested Queries" was switched...