[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