#28 OCI8: Cannot allocate OCI handle.

closed
nobody
None
5
2009-02-15
2009-01-27
Anonymous
No

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 2 (Build 2600)
COMCTL32.DLL: 6.0.2900.2180
OCI.DLL: 10.2.0.1.0

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

Discussion

  • randolf_geist
    randolf_geist
    2009-01-27

    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

     
  • randolf_geist
    randolf_geist
    2009-02-15

    • status: open --> closed