Skip to Content.
Sympa Menu

freetds - [freetds] ORA-28528: Heterogeneous Services datatype conversion error

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Bass, Jeff" <JMBass AT ButlerMfg.Com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] ORA-28528: Heterogeneous Services datatype conversion error
  • Date: Thu, 9 Oct 2008 09:07:26 -0500

OS
RH EL 4.5 x86_64
Software
unixODBC-2.2.11
FreeTDS 0.64
Oracle Database Gateway

We are attempting to communicate from Oracle 9i to Microsoft SQL Server
2005 through ODBC.

I am getting the following error when selecting from a column defined as
int (varchar and datetime work):
ERROR:
ORA-28528: Heterogeneous Services datatype conversion error
ORA-02063: preceding line from VPSQL
no rows selected

Several notes have indicated that this is caused by the ODBC drivers
handling the SQLLEN value as a 32-bit value instead of a 64-bit value.

We have verified that we have the 64-bit versions of all the software.

We have installed unixODBC-2.2.11 from a tar file using
./configure --enable-gui=no CFLAGS="-DBUILD_REAL_64_BIT_MODE"
make
make install

We have then installed FreeTDS 0.64 from a tar file (rpm didn't create
the libtdsodbc.so) using
./configure -with-unixodbc=/usr/local -with-tdsver=8.0
make
make install

I am still getting the ORA-28528 and ORA-02063 errors.

Did we miss something?




  • [freetds] ORA-28528: Heterogeneous Services datatype conversion error, Bass, Jeff, 10/09/2008

Archive powered by MHonArc 2.6.24.

Top of Page