RE: Oracle Transparent Gateway for MS SQL *Server - Help!!
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <sriram_kr_2000@xxxxxxxxx>, <Oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 17 Jun 2005 14:57:41 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sriram Ramachandran Sent: Friday, June 17, 2005 2:34 PM To: Oracle-l@xxxxxxxxxxxxx Subject: Oracle Transparent Gateway for MS SQL *Server - Help!! We are running Oracle 22.214.171.124 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
Other related posts:
- » Oracle Transparent Gateway for MS SQL *Server - Help!!
- » RE: Oracle Transparent Gateway for MS SQL *Server - Help!!