[unixODBC-support] ISQL Error on Connect to DB2

Nick Gorham nick at lurcher.org
Sat Mar 28 01:06:01 GMT 2009


Martin J. Evans wrote:
> Ralph Hershkowitz/NYLIM wrote:
>> oracle at pnyorclux83:/usr/local/etc> isql -v NYL nylife xyz
>> [01000][unixODBC][Driver Manager]Can't open lib
>> '/opt/home1/db2inst1/sqllib/lib/libdb2.so' : ld.so.1: isql: fatal:
>> /opt/home1/db2inst1/sqllib/lib/libdb2.so: wrong ELF class: ELFCLASS64
>> [ISQL]ERROR: Could not SQLConnect
>
> So I'd guess this is running on a 64bit machine? and given it is /opt 
> - possibly Solaris?
>
> isql/unixODBC is built 32bit and your ODBC driver is 64bit - you 
> cannot mix. You need a 32bit isql/unixODBC and ODBC driver or a 64 bit 
> isql/unixODBC and ODBC driver - not one of each. Get/rebuild unixODBC 
> 64bit and use your existing ODBC driver or get a 32bit DB2 driver and 
> keep existing unixODBC (I'd actually recommend the latter for now as 
> I'm guessing the next issue is going to be whether SQLLEN is the same 
> size in unixODBC and DB2 if you use the 64bit versions). Nick will be 
> more up to date than me on this and I'm sure he'll see this thread later.
>
> Martin
>
If you use 2.2.14 then I think the default SQLLEN size will match, but 
the big question is what app do you hope to use, there is no point 
installing a 64bit unixODBC is its eventually going to be used with a 64 
bit app.


-- 
Nick


More information about the unixODBC-support mailing list