[freetds] Getting ORA-28528: Heterogeneous Services datatypeconversion error
Frediano Ziglio
freddy77 at gmail.com
Tue Mar 30 03:52:03 EDT 2010
Hi,
if you followed the link you post initially
(http://www.gotodba.com/install-and-configure-db-link-to-sql-server-database-in-linux.html)
you compiled from sources (configure and make is the "standard" way
many programs use to compile). Oracle suggestion (upgrade unixODBC to
2.2.14) is IMHO mandatory. You could download updated version from
http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/ (patched) and
follow same steps you found in the link.
Regards
Frediano Ziglio
2010/3/26 Vadala, Sreedhar <svadala at icgcommerce.com>:
> 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: freetds-bounces at lists.ibiblio.org [mailto:freetds-bounces at lists.ibiblio.org] 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 <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 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
>>
>> **********************************************************************
>>
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS at lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
More information about the FreeTDS
mailing list