#47 OCI8: Cannot allocate OCI handle

[Anonymous]

Please submit a bug in the SQLTools++ bug tracker:
http://sourceforge.net/tracker/?func=add&group_id=220648&atid=1050077
You could also mail this information to <errors@sqltools-plusplus.org>.
We need the stack trace (see below) and short description
what were you doing when this problem occurred.

OCI8: Cannot allocate OCI handle.

Program: SQLTools_pp 1.21 RC3 (for trouble-shooting)
Location: .\SQLTools.cpp(249).
Platform: MS Windows XP Professional, Service Pack 3 (Build 2600)
COMCTL32.DLL: 6.0.2900.5512
OCI.DLL: 9.2.0.1.0

Stack at the catch point:
0x7c91e514 KiFastSystemCallRet() + 0

[randolf_geist]

This error usually indicates that you have an incomplete Oracle Client
installed. Note that SQLTools++ requires an fully functional Oracle
Client.

The simplest way to get one is to use the "Instant Client" available for
download from here:

http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

The version is not that important, I would usually recommend to use the
latest one, currently 11.1.0.7.0. The "Basic" package should be
sufficient.

You can extract the downloaded archive anywhere and then change the
"Start
In" directory of the SQLTools++ link to the directory where you've
extracted the "Instant Client" files.

If you want to use the TNSNAMES.ORA file to resolve your database aliases
together with the "Instant Client", you might need to set the environment
variable TNS_ADMIN to point to the directory where the TNSNAMES.ORA file
resides.

Best Regards,
Randolf Geist