Re: Ubuntu Server VM

[Matt Lavinder <mlavinder@xxxxxxxxxxxxxxxxxxx>]

That's been my thought.  Here is the output:

-rwxr-xr-x 1 root root 8545798 Nov  3 12:23 libcwbcore.so
-rwxr-xr-x 1 root root 5416205 Nov  3 12:23 libcwbodbc.so
-rwxr-xr-x 1 root root  194469 Nov  3 12:23 libcwbodbcs.so

The permissions are set exactly like they are for /usr/lib.  Already 
changed those.

On 4/10/2015 11:24 AM, Jim Oberholtzer wrote:
> 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