[prev in list] [next in list] [prev in thread] [next in thread]
List: freetds
Subject: Re: [freetds] Issue with FreeTDS and Oracle DG4ODBC
From: "Anton Bayliss [DATACOM]" <AntonB () datacom ! co ! nz>
Date: 2008-10-30 20:17:36
Message-ID: 3BE53D000F2EB846B8A899CD0DECB93205495C54 () dnzakex1 ! datacom ! co ! nz
[Download RAW message or body]
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:
antonb@datacom.co.nz
-----Original Message-----
From: freetds-bounces@lists.ibiblio.org
[mailto:freetds-bounces@lists.ibiblio.org] 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
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic