[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2009-05-10
2
Medium Priority
?
841 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 71

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

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

834 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