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

Thread: Accessing SQL Server from Oracle package

  1. 04-18-2001, 03:25 PM #1
    spunky
    spunky is offline Junior Member
    Join Date
    Apr 2001
    Posts
    1
    I have an Oracle package which needs to extract data from a remote SQL Server. I have been given a login, password, and IP address to the SQL 7 Server and need to establish connectivity. How do I go about this? Thanks
    Reply With Quote Reply With Quote
  2. 04-18-2001, 03:30 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You need a piece of software called Transparent Gateway by Oracle. It will allow you to see your sqlserver database as an oracle database.
    Jeff Hunter
    Reply With Quote Reply With Quote
  3. 04-18-2001, 04:16 PM #3
    jrpm
    jrpm is offline Senior Member
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295

    Unhappy

    I have recently seen some traffic, if not here then on other boards, about using ODBC from Oracle (may PL/SQL) to access SQL Server. Is there anyone who can tell me where to look for more info on this? Or who will give an overview of how?
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'
    Reply With Quote Reply With Quote
  4. 04-18-2001, 07:49 PM #4
    buggy88
    buggy88 is offline Junior Member
    Join Date
    Apr 2001
    Posts
    10
    You could find more information from technet.oracle.com

    http://technet.oracle.com/products/g..._techsheet.pdf
    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