Re: Getting ORA-28528: Heterogeneous Services data type conversion error

2010/3/25 Vadala, Sreedhar <[email protected]>:
> 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.
>

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
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds