Hello,
Is there any way to connect oracle to Sql Server.
Thank you for help.

yes there is, look it up on otn

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.

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:

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

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?

Hi,

You can download the SQL Server ODBC driver here:

http://www.microsoft.com/downloads/details...bf-acace5369fa3

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:

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

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?