Oracle Database Discussions

Hi,

I am getting below error when querying (also with oracle reports) MS SQL 2008 database talbes which are having more rows. There is no issue with tables with less number of rows.
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from SQLSERVER

When i am querying "select * from "Areas"@sqlserver;", it is retriving 195 rows and then displaying above error. This table contains 10716 rows.

Below are our environment details:

Oracle database 11G RAC (2 nodes) on RHEL 5 64 Bit, MS SQL 2008

ODBC.INI
[oracle@proddb1 ~]$ cat /etc/odbc.ini
[ODBC Data Sources]
mssql=MS SQL Server

[mssql]
Driver=/opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0
Database=Ksa_Fakieh_SFA
LogonID=OracleUser
Password=0r@cle999
Server=SJSQLV01.fakiehgroup.com
QuotedId=YES
AnsiNPW=YES
[ODBC]
IANAAppCodePage=4
Trace=0
UseCursorLib=0
UseCursorLib=0


INIT FILE:

[oracle@proddb1 ~]$ cat $ORACLE_HOME/hs/admin/initDG4ODBC.ora
# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = mssql
HS_FDS_TRACE_LEVEL = off
HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so
HS_FDS_SUPPORT_STATISTICS=FALSE
HS_LANGUAGE = AMERICAN_AMERICA.AR8MSWIN1256
HS_NLS_NCHAR=UCS2
#
# ODBC specific environment variables
#
set ODBCINI=/etc/odbc.ini
#


Listener.ora:

# ###############################################################

#

TRACE_FILE_LISTENER_PRODDB1 = fakieh1

LISTEN_DG4ODBC =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = proddb1.fakiehgroup.com)(PORT = 1511))
)
)
SID_LIST_LISTEN_DG4ODBC =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /u01/oracle/fakieh/db/tech_st/11.1.0)(SID_NAME=DG4ODBC)
(ENV="LD_LIBRARY_PATH=/usr/lib64:/u01/oracle/fakieh/db/tech_st/11.1.0/lib")
(PROGRAM=dg4odbc)
)
)

#
# Definition for RAC Database listener
#

LISTENER_PRODDB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = proddb1-vip.fakiehgroup.com)(PORT = 1521)(IP = FIRST)))
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = proddb1)(PORT = 1521)(IP = FIRST)))
)
)

SID_LIST_LISTENER_PRODDB1 =
(SID_LIST =
(SID_DESC = (ORACLE_HOME = /u01/oracle/fakieh/db/tech_st/11.1.0)(SID_NAME = fakieh1))
)

STARTUP_WAIT_TIME_LISTENER_PRODDB1 = 0
CONNECT_TIMEOUT_LISTENER_PRODDB1 = 10
TRACE_LEVEL_LISTENER_PRODDB1 = OFF

LOG_DIRECTORY_LISTENER_PRODDB1 = /u01/oracle/fakieh/db/tech_st/11.1.0/network/admin
LOG_FILE_LISTENER_PRODDB1 = fakieh1
TRACE_DIRECTORY_LISTENER_PRODDB1 = /u01/oracle/fakieh/db/tech_st/11.1.0/network/admin
TRACE_FILE_LISTENER_PRODDB1 = fakieh1
ADMIN_RESTRICTIONS_LISTENER_PRODDB1 = ON
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER_PRODDB1 = OFF


IFILE=/u01/oracle/fakieh/db/tech_st/11.1.0/network/admin/fakieh1_proddb1/listener_ifile.ora


Thank You,
Mohammed.