Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Transparent Gateway for MS SQL *Server - Help!!

RE: Oracle Transparent Gateway for MS SQL *Server - Help!!

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Fri, 17 Jun 2005 14:57:41 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA6502988BB1@25exch1.vicorpower.vicr.com>


Sriram,

        There are three config files you need to be aware of. The listener.ora and TM4sql.ora(or whatever other name you've used) files on the SQL*server system, and the tnsnames.ora file on the host DB. The biggest thing I've run into was setting "hs = ok" in the tnsnames.ora file. Otherwise it's pretty straight forward. Try a read through the Administrators guide which is on the CD.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sriram Ramachandran Sent: Friday, June 17, 2005 2:34 PM
To: Oracle-l_at_freelists.org
Subject: Oracle Transparent Gateway for MS SQL *Server - Help!!

We are running Oracle 9.2.0.5 on RedHat 3.0 and we want to connect to MS SQL*Server on Windows 2000 Server using Oracle Transparent Gateway.

I'm a bit confused on how to set it up after reading some of the metalink notes. Has anyone configured or used it? I would appreciate if you can share with me the steps to configure the same.

Thanks,
Sriram                 



Yahoo! Sports
Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Fri Jun 17 2005 - 15:03:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US