[csw-users] unixodbc available as 64bit package?

[Stefan Tomlik]

Dennis Clarke wrote:
>   If you file a bug report against this package then it will be looked at
> during bug review. What you are asking for seems entirely reasonable and
> in fact, needed.
>   
Okay, done: http://www.blastwave.org/mantis/view_bug_page.php?f_id=0002602

There is another issue with this package, but I'm not sure if it is a 
bug in unixodbc. I would like to keep the libraries and binaries from 
oracle instantclient in a separate directory (in my case 
/opt/oracle/instantclient_10_2/) and it looks like I'm forced to use 
LD_LIBRARY_PATH, apart from various other brainf***ed environment 
variables required by the odbc driver:

<snip>
-bash-3.00$ unset LD_LIBRARY_PATH
-bash-3.00$ /opt/csw/bin/isql -v OracleTestServer
[01000][unixODBC][Driver Manager]Can't open lib 
'/opt/oracle/instantclient_10_2/libsqora.so.10.1' : ld.so.1: isql: 
fatal: libclntsh.so.10.1: open failed: No such file or directory
[ISQL]ERROR: Could not SQLConnect
-bash-3.00$ export LD_LIBRARY_PATH=/opt/oracle/instantclient_10_2/
-bash-3.00$ /opt/csw/bin/isql -v OracleTestServer
[01000][unixODBC][Driver Manager]Can't open lib 
'/opt/oracle/instantclient_10_2/libsqora.so.10.1' : ld.so.1: isql: 
fatal: libodbcinst.so.1: open failed: No such file or directory
[ISQL]ERROR: Could not SQLConnect
-bash-3.00$ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/csw/lib
-bash-3.00$ /opt/csw/bin/isql TESTDB scott tiger -v
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
</snip>

Is it an expected behaviour that isql isn't able to find it's libraries 
when you set LD_LIBRARY_PATH? Is there any other way I can do that to 
get the stuff running?

-- 
"I can give it to you cheap, quick, and good. Now pick two out of the three"