FreeTDS Development Group

["Vadala, Sreedhar" <svadala AT icgcommerce.com>]

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@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

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