[freetds] Issue with FreeTDS and Oracle DG4ODBC
Anton Bayliss [DATACOM]
AntonB at datacom.co.nz
Wed Oct 29 19:19:25 EDT 2008
Hi.
I have set up FreeTDS 64bit with Oracle DG4ODBC 11.1.0.6 and it is
working most of the time but a particular SQL query returns:
ORA-28528: Heterogeneous Services datatype conversion error
I have logged this with Oracle support and they suggested the following:
Either -
1. Use a compatible 64-bit ODBC driver that handles SQLLEN as a 64-bit
value.
2. It may be possible to re-compile the driver to handle SQLLEN
correctly for 64-bit. See note 554409.1. Thi is to recompile the
ODBC driver after setting the flag -
CFLAGS="-DBUILD_REAL_64_BIT_MODE"
but you will have to to chekc with FreeTDS to see if this will work.
Will FreeTDs support this ? I installed FreeTDS version 0.82 from
download freetds-stable.tgz and used the following to install:
tar -zxvf freetds-stable.tgz
cd /root/install/freetds-0.82
make clean; make distclean
./configure -prefix=/opt/freetds --with-tdsver=8
make
make install
Any help ? Thanks.
More information about the FreeTDS
mailing list