• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 844
  • Last Modified:

ODBC Connection from Oracle 10g on Win2003 x64 to SQL Server

Hello,

We're trying to connect to SQL server from our Oracle 10g database that is on Windows 2003 Server x64.  Through issues encountered and then research I found that Oracle Heterogeneous services aren't supported in 64 bit, so I need some sort of solution to select information out of the SQL Server DB from the Oracle DB.  I checked out EasySoft's solutions but they are only offered for Unix or Linux platforms.  I also researched Oracle's DG4ODBC and DG4MSQL but they are only for 32 bit.

Does anyone have any suggestions or solutions to this at all?  This is a critical issue for us at this point and time.

Thanks,
Joe
0
sglew
Asked:
sglew
1 Solution
 
QlemoDeveloperCommented:
You can install Oracle Listener plus Gateway on a x86 machine, and use that machine as a gateway.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now