Help - Search - Members - Calendar
Full Version: How to Connect Oracle to SQL Server
Oracle DBA Forums > Oracle > Oracle Forum
Is there any way to connect oracle to Sql Server.
Thank you for help.
yes there is, look it up on otn
You have following options -
1. Transparent Gateway for MS SQL
2. Hetrogeneous Connectivity/ Generic connectivity.

Check for the compatibility with MS SQL server ver and the transparent Gateway.
I have a problem and i've been struggling for weeks now. I want to connect Oracle running on HP-UX to SQLserver running on windows 2003. How best can i do this? I need the easiest way possible.

Oracle: Oracle Database 10g Enterprise Edition Release 10.2.0
Unix: HP-UX dbtst01 B.11.23 you ia64

Please help
what have you come up with so far - what problem hve you hit
Was trying it using the easysoft ODBC driver. Managed to connect the driver but the problem is with the oracle. It keeps giving me this error:

SQL> select * from spmfdtgdev@sqlsrv;
select * from spmfdtgdev@sqlsrv
ERROR at line 1:
ORA-12537: TNS:connection closed

Please help
Try here:

Also, Excel_DB is a good way to extract and load data between SQL Server and Oracle:
The solution on this link - is exactly what i've configured.

I just wanted to find out something. On the first step it says install the driver on your laptop but it does not say where to get these drivers. Is there a website i can get these drivers from?

You can download the SQL Server ODBC driver here:
I need to connect Oracle on HP-UX to SQL server on Win2003 server.

I've just discovered that hsodbc is not supported on the 64bit version of Oracle. I've therefore been advised to use Transparent Gateway for ODBC (TG4ODBC). Any ideas where i can download this?

Is it true that this should be installed on the Windows SQL server?
>> I've therefore been advised to use Transparent Gateway for ODBC (TG4ODBC). Any ideas where i can download this?

Check with your Oracle CSI and make sure that you have the appropriate Oracle licenses in-place.

Also, check metalink for important usage tips for the transparent gateway:

Here is an exampole of using OTG with Oracle:
This time i am using dg4msql to connect Oracle 11g on windows 2003 to SQL server on Windows 2003.
I keep getting this error after configuring;

SQL> desc sysusers@sql
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.[Oracle][ODBC SQL Server
Driver][DBNETLIB]ConnectionOpen (Connect()).[Oracle][ODBC SQL Server Driver]Invalid connection string attribute
ORA-02063: preceding 2 lines from SQL

Does anyone have an idea what is happening?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2016 Invision Power Services, Inc.