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?