connect Oracle9i on Unix to MS Sql Server

[eeriehunk]

Hi, Please give me a lead on how to connect Oracle 9i which is on a unix machine to MS SQL Server and access its data. Does Oracle9i or TOAD have any inbuild functionality to make connections and access data.

[debasisdas]

Please find related discussions here and here .

[eeriehunk]

Thank you for your reply but why Oracle is on a Unix server, we cannot use ODBC. There should be some thing else. I read these articles before they both talk about ODBC on Windows platform. Please reply if you have any info other than this?
Thanks

[debasisdas]

Thank you for your reply but why Oracle is on a Unix server, we cannot use ODBC. There should be some thing else. I read these articles before they both talk about ODBC on Windows platform. Please reply if you have any info other than this?
Thanks

ODBC is a windows only technology, which is not supported on other platforms.

[eeriehunk]

ODBC is a windows only technology, which is not supported on other platforms.

Yes .. That is what I said. So what is the solution when you have oracle on a unix machine.Please reply ?
Thanks,
Eeriehunk