Solved

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

Posted on 2009-05-10
2
809 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
2 Comments
 
LVL 68

Accepted Solution

by:
Qlemo earned 500 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MS SQL export CSV & schedule It 9 44
null value 15 65
SQL server 2008 SP4 29 33
Optimize/Performance Tune Production Databases 11 40
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

705 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now