ORA-28528: Heterogeneous Services datatype conversion error

"Bass, Jeff" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <A746EC93C83C0347A05F39A0F283311D0589ED9C@bmkc1svex01.steel.bhpsteel.net>
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?
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.