I have an Oracle database and a SQL Server database on 2 separate servers and have
the appropriate ODBC drivers installed on my Client machine. I have recently created some new tables on
Oracle that I want to query in a SQL Server stored procedure - but I don't want
to have to duplicate the tables on SQL Server. How can I access the tables as
if they were part of my SQL Server database?
I have read all the manual has to say about ODBC but I don't understand any of it!