Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Vadala, Sreedhar" <svadala AT icgcommerce.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Getting ORA-28528: Heterogeneous Services data type conversion error
  • Date: Wed, 24 Mar 2010 21:22:31 -0400

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
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

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





Archive powered by MHonArc 2.6.24.

Top of Page