[freetds] Getting ORA-28528: Heterogeneous Services data typeconversion error
Vadala, Sreedhar
svadala at icgcommerce.com
Fri Mar 26 10:54:53 EDT 2010
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: freetds-bounces at lists.ibiblio.org [mailto:freetds-bounces at lists.ibiblio.org] 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 <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
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
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 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
**********************************************************************
More information about the FreeTDS
mailing list