Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    6

    Unanswered: Oracle to MS SQL via ODBC

    Hi all

    Please, I need help with my problem. I had old server with WinNT and Oracle 9.0.1. This server was destroyed. Documentation to it unexists.

    I had on this server connection from Oracle to MS SQL via ODBC. I don't know set up it.

    Please, do you know, how can I set up it?

    Thanks a lot

    Reddy

  2. #2
    Join Date
    Jun 2003
    Posts
    10

    Re: Oracle to MS SQL via ODBC

    If you are trying to connect to a MS SQL database from Oracle in 9, you'd be better off using transparent gateways.


    ============================
    Originally posted by ReddySk
    Hi all

    Please, I need help with my problem. I had old server with WinNT and Oracle 9.0.1. This server was destroyed. Documentation to it unexists.

    I had on this server connection from Oracle to MS SQL via ODBC. I don't know set up it.

    Please, do you know, how can I set up it?

    Thanks a lot

    Reddy

  3. #3
    Join Date
    Jan 2004
    Posts
    6

    Cool Solved

    I solved it.

    I need edit hsodbc.ora, created init<dblink>.ora, edit tsnames.ora and created synonyms.

    Now I know that it's very simple.


    R.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •