Mar 17 2005, 03:43 AM
Is there any way to connect oracle to Sql Server.
Thank you for help.
Mar 17 2005, 04:37 AM
yes there is, look it up on otn
Mar 17 2005, 06:00 AM
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.
Jun 21 2008, 06:57 AM
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
Jun 21 2008, 09:17 AM
what have you come up with so far - what problem hve you hit
Jun 21 2008, 10:24 AM
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
Jun 21 2008, 10:29 AM
Also, Excel_DB is a good way to extract and load data between SQL Server and Oracle:http://www.excel-db.net
Jun 21 2008, 10:48 AM
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?
Jun 21 2008, 02:01 PM
Jun 23 2008, 07:52 AM
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?
Jun 23 2008, 03:50 PM
>> 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
Jul 2 2008, 08:20 AM
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