freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
[freetds] ORA-28528: Heterogeneous Services datatype conversion error
- From: "Bass, Jeff" <JMBass AT ButlerMfg.Com>
- To: <freetds AT lists.ibiblio.org>
- Subject: [freetds] ORA-28528: Heterogeneous Services datatype conversion error
- Date: Thu, 9 Oct 2008 09:07:26 -0500
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?
- [freetds] ORA-28528: Heterogeneous Services datatype conversion error, Bass, Jeff, 10/09/2008
Archive powered by MHonArc 2.6.24.