Re: Issue with FreeTDS and Oracle DG4ODBC
"Anton Bayliss [DATACOM]" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Thanks very much for the reply. So I must recompile unixODBC with the flag then recompile FreeTDS ? Anton Bayliss DATACOM | Senior Oracle DBA 1st Floor, 75 Rostrevor St | P.O. Box 9144 | Hamilton | New Zealand Ph: 64 7 839 9707 | Fax: 64 7 839 1721 | Cell: 64 21 391 573 | Email: [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Frediano Ziglio Sent: Thursday, 30 October 2008 9:27 p.m. To: FreeTDS Development Group Subject: Re: [freetds] 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. > FreeTDS is compatible > 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: > > This flag is a DM (Driver Manager) flag specifically a unixODBC flag. It change some defines in ODBC includes, FreeTDS should detect odbc_config flags and compile with proper definitions. Note that you MUST compile all stuff (Oracle Heterogeneous Services, unixODBC and FreeTDS) with the same flags!! > > tar -zxvf freetds-stable.tgz > cd /root/install/freetds-0.82 > > make clean; make distclean > > > > > ./configure -prefix=/opt/freetds --with-tdsver=8 > I think is --prefix here > make > > make install > Ok, steps are correct. Only make install require root access (and only cause prefix use system directories). > Any help ? Thanks. > bye freddy77 _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds