[freetds] Getting ORA-28528: Heterogeneous Services data type conversion error
Frediano Ziglio
freddy77 at gmail.com
Fri Mar 26 10:34:27 EDT 2010
2010/3/25 Vadala, Sreedhar <svadala at icgcommerce.com>:
> 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.
>
Versions ??
Some time ago we discovered a problem with date fields, you should use
an updated 0.82 version with patches from freetds.sf.net (or get
updated version).
bye
freddy77
More information about the FreeTDS
mailing list