[freetds] ORA-28528: Heterogeneous Services datatype conversion error
JMBass at ButlerMfg.Com
Thu Oct 9 10:07:26 EDT 2008
RH EL 4.5 x86_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):
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"
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
I am still getting the ORA-28528 and ORA-02063 errors.
Did we miss something?
More information about the FreeTDS