RE: Oracle connection to SQL Server

RE: Oracle connection to SQL Server

 

  

www.unixodbc.org may provide what you need (I think free)....

OR.

www.datadirect.com (not free)

New ODBC drivers from Intersolv

DataDirect ODBC drivers from Intersolv allowing connectivity
to the following data sources:

ASCII files
Btrieve
DB/2
dBASE
Excel
Informix
Ingres
Oracle7
Paradox
SQLBase
SQL Server
Sybase System 10 & 11


Martin
-----Original Message-----
From: Paul.Andrews
[mailto:oracledba-ezmlmshield-x35068275.[Email address protected]
Sent: Thursday, October 05, 2006 6:25 AM
To: LazyDBA Discussion
Subject: Oracle connection to SQL Server

In an earlier post I asked how to get data from SQL Server to Oracle.
Unfortunately we tried to create a HODBC connection from Oracle to SQL
Server, which did not work as Oracle is on a UNIX platform and SQL
Server is on Windows.



Is there any open-source ODBC driver that we can use to allow us to
retrieve data from SQL Server and store it in Oracle?



Paul




______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





Oracle LazyDBA home page