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

Thread: Oracle to Sqlserver

  1. #1
    Join Date
    Feb 2005
    Posts
    1

    Oracle to Sqlserver

    I need to poll a sqlserver database using a select statement from an Oracle Unix instance to gather informtion from the Sqlserver table and to pull information of a certain type.

    I am aware of Oracle Heterogeneous services but since this is a Unix box it seems like I need to buy an expensive ODBC driver from an outside vendor to get this done.

    The other opinion are some Java ODBC drivers but it sounds like I then have to construct Java Sql instead of native Sql.


    Does anyone know a better way? There are other architectural opinions but am I missing information on the ODBC front?

  2. #2
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    151
    Try reading on 'Oracle's Transparent Gateway', see if it meets your requirement.

    Goodluck

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