Getting ORA-28528: Heterogeneous Services data type conversion error

Hi,

 

Now I am getting below error after entering below setting in
initsqldb.ora file.  Any ideas to resolve the issue.

 

ORA-28528: Heterogeneous Services datatype conversion error

ORA-02063: preceding line from ICGC_SESSION_ODBC

 

 

#

# HS init parameters

#

HS_FDS_CONNECT_INFO = SQLDB

HS_FDS_TRACE_LEVEL = OFF

#HS_FDS_TRACE_LEVEL = 4

HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so

 

[oracle@dldb110 admin]$ vi initsqldb.ora

# This is a sample agent init file that contains the HS parameters that
are

# needed for the Database Gateway for ODBC

#

# ODBC specific environment variables

#

set ODBCINI=/etc/odbc.ini

 

HS_FDS_SUPPORT_STATISTICS = FALSE

 

#

# Environment variables required for the non-Oracle system

#

#set <envvar>=<value>

#HS_NLS_NCHAR = AMERICAN_AMERICA.US7ASCII

#HS_LANGUAGE = AMERICAN_AMERICA.US7ASCII

HS_NLS_NCHAR = AMERICAN_AMERICA.US7ASCII

HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P1

 

HS_FDS_SQLLEN_INTERPRETATION=64

HS_FDS_TIMESTAMP_

 

 

Thanks,

Sreedhar.


**********************************************************************
This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information of ICG Commerce.  If you have received this message in error, please e-mail administrator at [email protected], then delete the e-mail and destroy any printed copy.   ICG Commerce reserves the right to retain, archive, use and disclose any emails that are sent from or to this email address. Thank you.

www.icgcommerce.com

**********************************************************************