Help - Search - Members - Calendar
Full Version: How to Connect Oracle to SQL Server
Oracle DBA Forums > Oracle > Oracle Forum
souissitijani
Hello,
Is there any way to connect oracle to Sql Server.
Thank you for help.
dave
yes there is, look it up on otn
vishv
Hello,
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.
pachemwi
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
dave
what have you come up with so far - what problem hve you hit
pachemwi
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
burleson
Try here:

http://www.dba-oracle.com/t_connecting_sql_server_oracle.htm

Also, Excel_DB is a good way to extract and load data between SQL Server and Oracle:

http://www.excel-db.net
pachemwi
The solution on this link - http://www.dba-oracle.com/t_connecting_sql_server_oracle.htm 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?
burleson
Hi,

You can download the SQL Server ODBC driver here:

http://www.microsoft.com/downloads/details...bf-acace5369fa3
pachemwi
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?
burleson
>> 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:

http://www.dba-oracle.com/oracle_news/2004_5_10_gay.htm

Here is an exampole of using OTG with Oracle:

http://www.remote-dba.cc/t_oraclestreams_393_data_flow_.htm
pachemwi
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
ERROR:
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-2014 Invision Power Services, Inc.