[freetds] Getting ORA-28528: Heterogeneous Services data type conversion error

Vadala, Sreedhar svadala at icgcommerce.com
Wed Mar 24 21:22:31 EDT 2010


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 at 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 postmaster at icgcommerce.com, 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

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




More information about the FreeTDS mailing list