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?
2 Answers
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.