Re: Getting ORA-28528: Heterogeneous Services datatypeconversion error

Hi Freddy,

Thanks for the quick response, Can you please elaborate on "compile from sources". Where can I get the instructions? Any instructions would be appreciated.
We have downloaded the FreeTDS 6 month ago. Instructions for Patch would be appreciated as well.

Thanks,
Sreedhar.

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Frediano Ziglio
Sent: Friday, March 26, 2010 11:28 AM
To: FreeTDS Development Group
Subject: Re: [freetds] Getting ORA-28528: Heterogeneous Services datatypeconversion error

unixODBC can be a problem. I cannot find a solution, I don't have an
Oracle to test... we solve the problem with user help. Patch is quite
recent (some months ago) and probably if you have a packaged version
you'll have problems with date, I suggest to compile from sources.

freddy77

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