Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help Configuring Transparent Gateway for Ms Sql Server

155609Dec 19 2002 — edited Jun 9 2004
I have Installed Oracle 9.2.0.1.0 with Transparent Gateway for Ms Sql Server.

Followed the configuration furnished therein the Documents for Tnsnames.ora & Listener.ora.

Connection to Sql Server 2000 is NOT SUCCESSFUL. Trace File contents from Tg4sql is furnished below :

Oracle Corporation --- WEDNESDAY DEC 18 2002 22:32:50.625

Heterogeneous Agent Release
9.2.0.1.0

HS Agent diagnosed error on initial communication,
probable cause is an error in network administration
Network error 2: NCR-00002: NCR: Invalid usage

Note :- Sql Server & Oracle Server are on the same Machine running of Windows 2000 Server.


Am i missing something !!!

TIA
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2004
Added on Dec 19 2002
#heterogeneous-connectivity
13 comments
2,182 views