Oracle Database Discussions

I am using Oracle gateway for sqlserver 11.2 on Oracle 11.2 database on Linux.

When i run the following query:

select * from prc.PrcIsr@sqlserver;

then after displaying about 10,000 rows, i get the following error message:

ERROR:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from SQLSERVER

This error comes for all the tables except for minor tables having less than 1000 rows.

Followings are the contents from the trace file:

hgopoer, line 233: got native error 5701 and sqlstate 01000; message follows...
[Oracle][ODBC SQL Server Driver][SQL Server]Changed database context to 'qai'. {01000,NativeErr = 5701}[Oracle][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english. {01000,NativeErr = 5703}[Oracle][ODBC SQL Server Driver]Invalid connection string attribute {01S00}
Exiting hgopoer, rc=0 at 2011/10/12-07:01:30
hgocont, line 2685: calling SqlDriverConnect got sqlstate 01000
Entered hgolosf at 2011/10/12-07:01:30
Exiting hgolosf, rc=0 at 2011/10/12-07:01:30
DriverName:HGmsss23.so, DriverVer:06.00.0056 (b0041, U0039)
DBMS Name:Microsoft SQL Server, DBMS Version:09.00.4060
Exiting hgocont, rc=0 at 2011/10/12-07:01:30 with error ptr FILE:hgocont.c LINE:2685 FUNCTION:hgocont() ID:SQLDriverConnect
SQLGetInfo returns Y for SQL_CATALOG_NAME

hgopoer, line 233: got native error 104 and sqlstate 01000; message follows...
[Oracle][ODBC SQL Server Driver][libssclient24]ConnectionRead (recv()). {01000,NativeErr = 104}[Oracle][ODBC SQL Server Driver][libssclient24]General network error. Check your network documentation. {08S01,NativeErr = 11}
Exiting hgopoer, rc=0 at 2011/10/12-07:03:27
hgoftch, line 730: calling SQLFetch got sqlstate 01000
 0 rows fetched
Exiting hgoftch, rc=28500 at 2011/10/12-07:03:27 with error ptr FILE:hgoftch.c LINE:730 FUNCTION:hgoftch() ID:Fetch resultset data

Listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.2.134)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = dg4msql)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (PROGRAM = dg4msql)
    )
  )

sqlnet.ora

# sqlnet.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /u01/app/oracle

initdg4msql.ora

# This is a customized agent init file that contains the HS parameters
# that are needed for the Database Gateway for Microsoft SQL Server

#
# HS init parameters
#
HS_FDS_CONNECT_INFO=[zeus.lhr.com]:1433//qai
# alternate connect format is hostname/serverinstance/databasename
HS_FDS_TRACE_LEVEL=DEBUG
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
# custom init parameters
HS_KEEP_REMOTE_COLUMN_SIZE=LOCAL
HS_NLS_LENGTH_SEMANTICS=CHAR
HS_LANGUAGE=AMERICAN_AMERICA.WE8MSWIN1252
HS_NLS_NCHAR=UCS2