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 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: