Isql error on AIX 6.1

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Isql error on AIX 6.1

c2dove

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
---------------------------------------------------------------------


_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Isql error on AIX 6.1

Nick Gorham-2
On 29/08/14 20:35, Dove, Charles wrote:

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


Is the .o a library that can be dynamically loaded?

--
Nick

_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Isql error on AIX 6.1

David Ritter-3

When I use the DB2 9.7 client on AIX with unixODBC this is the shared object I specify in my odbcinst.ini

 

Driver=/db/db2/v9.7_fp2/db0902c1/sqllib/lib32/db2.o

 

Hth,

Dave

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Nick Gorham
Sent: Friday, August 29, 2014 2:12 PM
To: Support for the unixODBC project
Subject: Re: [unixODBC-support] Isql error on AIX 6.1

 

On 29/08/14 20:35, Dove, Charles wrote:

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


Is the .o a library that can be dynamically loaded?

--
Nick


_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Isql error on AIX 6.1

c2dove
In reply to this post by Nick Gorham-2

Yes!

 

 

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Nick Gorham
Sent: Friday, August 29, 2014 5:12 PM
To: Support for the unixODBC project
Subject: Re: [unixODBC-support] Isql error on AIX 6.1

 

On 29/08/14 20:35, Dove, Charles wrote:

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


Is the .o a library that can be dynamically loaded?

--
Nick


---------------------------------------------------------------------
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
---------------------------------------------------------------------


_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Isql error on AIX 6.1

Nick Gorham-2
In reply to this post by c2dove
On 29/08/14 20:35, Dove, Charles wrote:

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


Just about whenever I have seen that error its from a dependent lib. Haver you got anything like strace/truss to watch the OS loading the lib and see where it gives up?

--
Nick

_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Isql error on AIX 6.1

David Ritter-3

I *think* I may see the problem.  If you are using a 64-bit build of unixODBC it will not be able to dlopen the 32-bit DB2 client library (which is what you have specified in your odbcinst.ini).

 

The 64-bit library will require a Driver entry that looks like this (from my AIX system):

 

Driver=/db/db2/v9.7fp7/db9707c2/sqllib/lib64/db2o.o

 

So I think for yours:

 

[DB2]

Description     = DB2 driver

Driver          =  /home/db2/dsalldvi/sqllib/lib64/db2o.o

 

And of course make sure that /home/db2/dsalldvi/sqllib/lib64 is set in your LIBPATH environment variable (which it looks like it is).

 

Hth,

Dave

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Nick Gorham
Sent: Friday, August 29, 2014 3:30 PM
To: Support for the unixODBC project
Subject: Re: [unixODBC-support] Isql error on AIX 6.1

 

On 29/08/14 20:35, Dove, Charles wrote:

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


Just about whenever I have seen that error its from a dependent lib. Haver you got anything like strace/truss to watch the OS loading the lib and see where it gives up?

--
Nick


_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Loading...