[unixODBC-support] Isql error on AIX 6.1

Dove, Charles Charles.Dove at firstcitizens.com
Fri Aug 29 20:35:15 BST 2014


To support:
    On AIX 6.1 trying to use unixODBC to connect to DB2
64 bit compile of unixODBC version 2.3.2

Odbcinst.ini
[ODBC]
Trace           = yes
TraceFile       = /tmp/sql.log

[DB2]
Description     = DB2 driver
Driver          =  /home/db2/dsalldvi/sqllib/lib/db2o.o

Odbc.ini
[sample]
Description = DB2 test
Driver =  DB2
Database = DSTFBDV
Servername = aadarsvrmsd11d.aaa.com
Port = 51010

DB2LIB=/home/db2/dsalldvi/sqllib/lib
IBM_DB_LIB=/home/db2/dsalldvi/sqllib/lib
LIBPATH=/usr/local/unixODBC/lib::/usr/lib:/lib:/usr/local/lib:/opt/freeware/lib:/usr/local/samba/lib:/home/db2/dsalldvi/sqllib/lib64:/home/db2/dsalldvi/sqllib/lib
LD_LIBRARY_PATH=/usr/local/unixODBC/lib:/home/db2/dsalldvi/sqllib/lib64:/home/db2/dsalldvi/sqllib/lib

Isql -v sample   gets following error
[unixODBC][Driver Manager]Can't open lib '/home/db2/dsalldvi/sqllib/lib/db2o.o' : file not found


This is the 64bit driver and file is in current location. I have run ldd on the file and nothing is missing!?!?!?!?

Any help would be greatly appreciated


Regards
Chris Dove
Information Technology|Data Warehouse & Decision Support | First Citizen Bank
FCB Mail Code:  DAC-71 | 100 E Tryon Road | Raleigh, NC 27603
Office:  919.716.4875





---------------------------------------------------------------------
Call 1.888.FC DIRECT (1.888.323.4732) or visit us on the web at www.firstcitizens.com today to take advantage of our great products and services.
This electronic mail and any files transmitted with it are confidential and are intended solely for the use of individual or entity to whom they are addressed. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that if you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail.
First Citizens Bank - Helping our customers achieve a lifetime of success. Visit us on the web at www.firstcitizens.com - Member FDIC
---------------------------------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20140829/33fdbb78/attachment.html>


More information about the unixODBC-support mailing list