Re: Getting ORA-28528: Heterogeneous Services data typeconversion error

Hi Freddy,

I am having issue with only NULL fields, getting a Date field are not an issue. Oracle Support asked me to upgrade unixODBC driver from 2.2.11 to 2.2.14.

Please let me know if you have any resolutions.

We are using 0.82version, but not sure with the patches.

cat freetds.conf
[global]
        # TDS protocol version
;       tds version = 4.2

[dwis110.dv.icgcnet.com]
        host = dwis110.dv.icgcnet.com
        port = 49338
        tds version = 8.0

Thanks,
Sreedhar.


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Frediano Ziglio
Sent: Friday, March 26, 2010 10:34 AM
To: FreeTDS Development Group
Subject: Re: [freetds] Getting ORA-28528: Heterogeneous Services data typeconversion 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

**********************************************************************
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 [email protected], 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

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

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds