× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Well, crud, I forgot to remove the user and password. I guess I'll be changing those now.


On 4/10/2015 11:18 AM, Matt Lavinder wrote:
I have been trying to get IBM i Client Access ODBC driver working on
Ubuntu 64-bit 14.04 and I cannot get it to work. This is the message
that has me stuck:

"Can't open lib '/opt/ibm/iaccess/lib64/libcwbodbc.so' : file not found"

Seems it is finding my DSN but it says it cannot find find the library.
The problem is, the files are there. I've tried copying them to
/usr/lib per several suggestions and it got me no where. The read
permissions are there, besides, if I do "sudo isql" I get the same
error. It is almost as if these files are in the wrong format, but I
used the .deb package, which is right for Ubuntu.

Below is my log output and my ini files. The odbcinst.ini is how the
package installer made it, but I added the lines for logging at the top
to try and get me information to no avail.

---------------
Log Output
---------------
This is the log output when I use isql to test the DSN:
[ODBC][2048][1428678790.310646][__handles.c][450]
Exit:[SQL_SUCCESS]
Environment = 0x1267750
[ODBC][2048][1428678790.310956][SQLAllocHandle.c][364]
Entry:
Handle Type = 2
Input Handle = 0x1267750
[ODBC][2048][1428678790.311041][SQLAllocHandle.c][482]
Exit:[SQL_SUCCESS]
Output Handle = 0x12680a0
[ODBC][2048][1428678790.311126][SQLConnect.c][3615]
Entry:
Connection = 0x12680a0
Server Name = [SYSTEM5][length = 7 (SQL_NTS)]
User Name = [PHPUSER][length = 7 (SQL_NTS)]
Authentication = [**********][length = 10 (SQL_NTS)]
UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

[ODBC][2048][1428678790.324707][SQLConnect.c][1064]Can't open lib
'/opt/ibm/iaccess/lib64/libcwbodbc.so' : file not found
[ODBC][2048][1428678790.325054][SQLFreeHandle.c][279]
Entry:
Handle Type = 2
Input Handle = 0x12680a0
[ODBC][2048][1428678790.325139][SQLFreeHandle.c][330]
Exit:[SQL_SUCCESS]
[ODBC][2048][1428678790.325226][SQLFreeHandle.c][212]
Entry:
Handle Type = 1
Input Handle = 0x1267750



---------------
odbcinst.ini
---------------
[ODBC]
Trace = yes
TraceFile = /home/mlavinder/odbc-trace.log

[IBM i Access ODBC Driver]
Description = IBM i Access for Linux ODBC Driver
Driver = /opt/ibm/iaccess/lib/libcwbodbc.so
Setup = /opt/ibm/iaccess/lib/libcwbodbcs.so
Driver64 = /opt/ibm/iaccess/lib64/libcwbodbc.so
Setup64 = /opt/ibm/iaccess/lib64/libcwbodbcs.so
Threading = 0
DontDLClose = 1
UsageCount = 1

[IBM i Access ODBC Driver 64-bit]
Description = IBM i Access for Linux 64-bit ODBC Driver
Driver = /opt/ibm/iaccess/lib64/libcwbodbc.so
Setup = /opt/ibm/iaccess/lib64/libcwbodbcs.so
Threading = 0
DontDLClose = 1
UsageCount = 1


---------------
odbc.ini
---------------
[SYSTEM5]
Description=primary
Driver=IBM i Access ODBC Driver
System=10.10.10.2
UserID=PHPUSER2
Password=DATAMAIL01
Naming=1
DefaultLibraries=QGPL
Database=SYSTEM5
ConnectionType=0
CommitMode=2
ExtendedDynamic=0
DefaultPkgLibrary=QGPL
DefaultPackage=A/DEFAULT(IBM),2,0,1,0,512
AllowDataCompression=1
LibraryView=0
AllowUnsupportedChar=0
ForceTranslation=0
Trace=0


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.