?
Solved

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

Posted on 2009-05-10
2
Medium Priority
?
846 Views
Last Modified: 2013-12-18
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
Comment
Question by:sglew
1 Comment
 
LVL 72

Accepted Solution

by:
Qlemo earned 2000 total points
ID: 24352799
You can install Oracle Listener plus Gateway on a x86 machine, and use that machine as a gateway.
0

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.

585 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question