can anyone tell me how to access to ms sql database from oracle from another computer? and i want to know which version of oracle should i use to do that?


The feature you need is called Oracle Transparent Gateway for Microsoft SQL Server in Oracle 10g. You can only create a DBLINK to another Oracle database out-of-the-box.


The term you need to look up is DATABASE LINK. Check out here too

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy