ODBC Connection from Oracle 10g on Win2003 x64 to SQL Server
Posted on 2009-05-10
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.