odbc - connecting to DB2 database:[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed -


odbc.ini:

[default] driver          = db2 [abc] driver          = db2 [dsn_test1] description = connection db2 driver          = db2

odbcinst.ini:

[db2] description = db2 driver driver = /home/user/sqllib/lib/libdb2.so fileusage=1 dontdlclose=1  [odbc] trace=1 tracefile=/home/user/sqllib/trace.out

db2cli.ini

[abc] hostname="hostname" pwd="passwd" port="port" protocol=tcpip database="dbname" uid="uid"

$ ./isql abc

+---------------------------------------+ | connected!                            | |                                       | | sql-statement                         | | [tablename]                      | | quit                                  | |                                       | +---------------------------------------+

while connecting db2 driver,below error coming:

connection attempt data source name "abc": =============================================================================== odbc driver manager path: /home/user/sqllib/odbclib/lib/libodbc.so  [failed]: [unixodbc][driver manager]driver's sqlallochandle on sql_handle_henv  failed

below snippet of odbc trace:

[odbc][23419][1403783774.660159][sqlconnect.c][1380]error: im004 [odbc][23419][1403783774.660223][sqlerror.c][434]     entry:         connection = 0x81aaac8         sqlstate = 0xffff9593         native = 0xffff9684         message text = 0xffff8d93         buffer length = 1024         text len ptr = 0xffff95bc [odbc][23419][1403783774.660260][sqlerror.c][471]     exit:[sql_success]         sqlstate = im004         native = 0xffff9684 -> 0         message text = [[unixodbc][driver manager]driver's sqlallochandle on sql_handle_henv failed]

googled lot root-cause,dint helped much,please provide pointer solve this. 32 bit linux machine having 32 bit db driver well.

according http://www-01.ibm.com/support/docview.wss?uid=swg21229860, im004 sqlstate on sqlallochandle indicates:

cause

the new security features introduced in db2® universal database™ (db2 udb) version 8.2 prevent users using database unless belong windows® groups db2admns or db2users.

and

answer

add userid (the 1 used execute application) either db2admns or db2users group. please refer link under "related information" (below) instructions on how accomplish this.

alternatively, there number of threads (e.g. http://mailman.unixodbc.org/pipermail/unixodbc-support/2010-september/002661.html) suggest setting db2instance environment variable match instance setting in odbc.ini file dsn concerned.


Comments

Post a Comment

Popular posts from this blog

javascript - RequestAnimationFrame not working when exiting fullscreen switching space on Safari -

request animation frame stops working when exiting fullscreen clicking on original space's safari window. fine if fullscreen mode canceled escape key or calling cancelfullscreen(). steps reproduce: open https://dl.dropboxusercontent.com/u/769042/prezi/safari-fullscreen.html click "draw raf", kittie appears click "fullscreen", go fullscreen click "draw raf", kittie appears go space original safari was, showing "click exit fullscreen mode", click anywhere, out fullscreen click "draw raf", nothing happens what handling click calling: window.requestanimationframe(draw); which draws on canvas context: function draw() { ctx.drawimage(img, math.random()*500|0, math.random()*400|0, 100, 100); } i checked .hidden , .visibilitystate, updated correctly. tested on osx 10.9.3, safari 7.0.4 (9537.76.4). has workaround/solution other switching old settimeout? this sounds webkit bug 88940 : using reque
Read more

Python ctypes access violation with const pointer arguments -

i have api i'm trying wrap in python (2.7.6 on win7) code using ctypes. here's api: client_dllfunc bool clientapi search_exporttoclipcopy(clienthsearch handle, int channel, lpctstr filename, const time_t& from, const time_t& to, const bool* cameras, int length, bool usepassword, lpctstr password, bool includetextin = false, bool excludeplayer = false); the issue i'm having cameras argument; , i've had issue other const pointer arguments well. here's how i'm wrapping api: def search_exporttoclipcopy(self, hsearch, csearch, filename, tfrom, tto, cameras, length, usepassword, password, includetextin=true, excludeplayer=false): exporttoclipcopy = self.sdkdll.search_exporttoclipcopy exporttoclipcopy.argtypes = [c_int, c_int, c_wchar_p, c_long, c_long, pointer(c_bool), c_int, c_bool, c_wchar_p, c_bool, c_bool] exporttoclipcopy.restype = c_bool exporttoclipcopy(hsearch, csearch, filename, tfrom, tto, cameras, length, usepassword, pass
Read more