[unixODBC-support] RE: RE: Repost - Install questions

Nick Gorham nick.gorham at easysoft.com
Thu Jun 21 13:46:50 BST 2007

Stein, Howard wrote:

>>All we do to build on Solaris 64, is
>>tar xvf unixODBC-2.2.12.tar.gz
>>cd unixODBC-2.2.12
>>CFLAGS="-xarch=v9 -KPIC -xcode=pic32"
>>export CFLAGS
>Well keep in mind we are talking about sparc hardware.  On the sparc
>hardware, solaris 10, if all 64 bit libraries are on your
>LD_LIBRARY_PATH and in order that they'll be found first before their 32
>bit counterparts you will be able to link.  If not your link will fail
>unless you use the -xarch=v9 for the linker.  Also, on the Oracle pay
>site, the person helping me, directed me to a private document they have
>on how to use their oracle driver with Oracle 10g on solaris sparc 64
>bit including how to compile unixODBC.  They use different parameters
>then you do for building.  (See below).  I can't very well tell them to
>fix their ODBC Driver and refuse to build the way they say it has to be
>In any case, I can either adjust my LD_LIBRARY_PATH or the preferred
>figure out how come the LDFAGS isn't flowing through.
>==> When 64-bit ODBC (recommended) should be used, following steps  have
>to be  done, too 
>==> CFLAGS="-xarch=v9 -xchip=ultra3 -xO3 -Xa -xstrconst -dalign -xF"
>==>  LDFLAGS="-xarch=v9"
>==> ac_cv_sizeof_long=8
>==> export
>==> LDFLAGS CFLAGS ac_cv_sizeof_long
Ok, thats fine, I just said how WE build it :-)

>Some new questions I have:
>1) What is the iusql as opposed to the isql?  The Oracle folks new about
>it and had me check out both, but I wondered what the difference(s) are.
Its the same, but it makes unicode calls into the driver manager instead 
of ansi ones.

>2) I was too tired last night to resolve the ld issue so just as a quick
>test I built the 32 bit with the sun compiler.  Interestingly, isql no
>longer gets the bus error and core dump but the other application I'm
>using is still getting the core dump.  If the sql statement is the same
>(select * from owner.table), and both are using the same oracle odbc
>library, any thoughts on why one would work and not the other?  I'm just
>looking for insights and theoretical to get me thinking a bit.
>3) Do you ever sleep?  Seems you post all day and night.  I appreciate
>that fact as well as all your assistance!
Any time now I suspect.

Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org

More information about the unixODBC-support mailing list