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

Bass, Jeff JMBass at ButlerMfg.Com
Thu Oct 9 10:07:26 EDT 2008


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?




More information about the FreeTDS mailing list