Oracle and SQL Server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle and SQL Server

  1. #1
    Join Date
    Nov 2007
    Posts
    6

    Question Oracle and SQL Server

    Hi,

    i have to connect to a sql server 2000 database from an oracle 10g database on sun solaris environment.
    how can I do that?

    tks
    max

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Look at Oracle's Heterogeneous Services ODBC agent documentation.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Nov 2007
    Posts
    6
    Thanks,
    I'm find some documentation, but no from oracle on sun-solaris to sql server....
    someone have some idea?

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    The only operating system specific item in your shopping list is the ODBC driver, other than that documentacion should be sound.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Apr 2007
    Posts
    16

    Tried Database link>

    Database Links is a handy feature in oracle that enables you to establish a connection bw your oracle database and another database(including sql server).

Posting Permissions

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



Click Here to Expand Forum to Full Width