Re: Q: Link OracleDB to MS SQL server

Thank you all for the responses.
I decided to implement Oracle Database Gateway for MS SQL server
http://download.oracle.com/docs/cd/B28359_01/gateways.111/b31043/conf_sql.htm

Atanas


Niall Litchfield wrote:
or if you are talking 11g the new name for the old thing is database gateway for ODBC.

On Sun, Mar 7, 2010 at 7:58 AM, Yechiel Adar <adar666@xxxxxxxxxxxx <mailto:adar666@xxxxxxxxxxxx>> wrote:

    Check out heterogeneous services.

    Adar Yechiel
    Rechovot, Israel




    Cholakov, Atanas Stoianov wrote:

        Hi All,

        I need to connect my Oracle DB to MS SQL server.

        I also need to have full rights (insert, update and delete)
         on a table there!

        Can you please share your experience?

        Cheers,
        Atanas

    --
    http://www.freelists.org/webpage/oracle-l





--
Niall Litchfield
Oracle DBA
http://www.orawin.info

begin:vcard
fn:Atanas Cholakov
n:Cholakov;Atanas
email;internet:cholakov@xxxxxxx
x-mozilla-html:FALSE
version:2.1
end:vcard

Other related posts: