RE: Ubuntu Server VM

That feels like an authority issue with the files/directories.. Have you
checked that?

--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Matt
Lavinder
Sent: Friday, April 10, 2015 10:19 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Ubuntu Server VM

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