| Message: 62577 |
 |
BY: Francesco Pellegrini (kranz)
DATE: 2008-11-28 10:39
SUBJECT: Problems with connection to iseries DB Hi
I have an application that after working perfectly for 6 months now suddenly gets an error when connecting to DB2: the error is:
Failed to connect to the [S653568C] due to: [IBM][CLI Driver] SQL30082N Security processing failed with reason "17" ("UNSUPPORTED FUNCTION"). SQLSTATE=08001 SQLCODE=-30082
This is very strange because nothing has been changed: AS/400 user is always the same, db2 connectivity from db2 connect is ok, command line db2cli works correctly, no upgrade to ibmdb driver has been made (currently 0.9.3).
So i put "DEBUGGER" in ibm_db_adapter.rb just before the line where the connection is made and found that the connection returns nil.
The very strange thing is that copying and pasting the line
connection = IBM_DB::connect "DRIVER={IBM DB2 ODBC DRIVER};\
DATABASE=#{database};\
HOSTNAME=#{host};\
PORT=#{port};\
PROTOCOL=TCPIP;\
UID=#{username};\
PWD=#{password};", '', '', conn_options
and executing it again, the connection does execute correctly and an #<IBM_DB::Connection:0xb72a3cc8> object is returned!
So why the hell is this happening???
Why executing two times the same command first time goes wrong and second time goes well????
| |
Start New Thread
Problems with connection to iseries DB