DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle and SQL Server

  1. 11-13-2007, 09:46 AM #1
    maxranzy
    maxranzy is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 11-13-2007, 09:48 AM #2
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    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.
    Reply With Quote Reply With Quote
  3. 11-13-2007, 11:33 AM #3
    maxranzy
    maxranzy is offline Junior Member
    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?
    Reply With Quote Reply With Quote
  4. 11-13-2007, 11:56 AM #4
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    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.
    Reply With Quote Reply With Quote
  5. 11-14-2007, 08:04 AM #5
    crimpe's Avatar
    crimpe
    crimpe is offline Junior Member
    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).
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width