Issue with FreeTDS and Oracle DG4ODBC

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.