Connecting to oracle through SQL server

Does any one have any information on connecting to an oracle database through SQL Server please?

In Query Analyzer you can use OpenDataSource(providername, connectionstring) to connect to other datasource like Oracle, Excel, Access etc.

Please use the "linked servers" feature. It requires an oracle client on your sql server machine.

Please read about it in books online. And note that performance is not very good when working with this feature because every query ahs to be executed twice.... without going into details. Please keep that in mind.


Kind regards
Henrik