freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] Getting ORA-28528: Heterogeneous Services data type conversion error
- From: Frediano Ziglio <freddy77 AT gmail.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] Getting ORA-28528: Heterogeneous Services data type conversion error
- Date: Fri, 26 Mar 2010 15:34:27 +0100
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@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] Getting ORA-28528: Heterogeneous Services data type conversion error,
Vadala, Sreedhar, 03/24/2010
-
Re: [freetds] Getting ORA-28528: Heterogeneous Services data type conversion error,
Frediano Ziglio, 03/26/2010
-
Re: [freetds] Getting ORA-28528: Heterogeneous Services data typeconversion error,
Vadala, Sreedhar, 03/26/2010
-
Re: [freetds] Getting ORA-28528: Heterogeneous Services data typeconversion error,
Frediano Ziglio, 03/26/2010
-
Re: [freetds] Getting ORA-28528: Heterogeneous Services datatypeconversion error,
Vadala, Sreedhar, 03/26/2010
- Re: [freetds] Getting ORA-28528: Heterogeneous Services datatypeconversion error, Frediano Ziglio, 03/30/2010
-
Re: [freetds] Getting ORA-28528: Heterogeneous Services datatypeconversion error,
Vadala, Sreedhar, 03/26/2010
-
Re: [freetds] Getting ORA-28528: Heterogeneous Services data typeconversion error,
Frediano Ziglio, 03/26/2010
-
Re: [freetds] Getting ORA-28528: Heterogeneous Services data typeconversion error,
Vadala, Sreedhar, 03/26/2010
-
Re: [freetds] Getting ORA-28528: Heterogeneous Services data type conversion error,
Frediano Ziglio, 03/26/2010
Archive powered by MHonArc 2.6.24.