SQL Server Gateway
Can't get Gateway to SQL Server to work...
Error from Oracle database when trying to access SQL Server DB, through DB Link that was set up in Oracle:
ORA-02068: following severe error from PMCDEV ORA-03114: not connected to ORACLE
Trace from gateway (for above Oracle error):
Remote HO Agent received unexpected RPC disconnect
status 2: ncrorpi_recv_procid, called from horg.c
(Gateway, Oracle Server, SQL Server on seperate machines.
Using Oracle 8.1.6, SQL Server 2000 on NT 4)
Because of the fact that the gateway creates a trace file, I assume that the listener etc is configured correctly and that the problem is on the gateway, not being able to connect to the SQL Server database or something. I have installed SQL Server client side software on gateway machine as a test, and it can connect to the SQL Server database with no problems.
What else needs to be installed on the gateway machine, except for the Gateway installation and the configuration as in the Oracle documentation? I have tried all kinds of different configurations but always get same result. I know it's probably something stupid that I overlooked, but I can't find the problem...