#28 OCI8: Cannot allocate OCI handle.


Please submit a bug in the SQLTools++ bug tracker:
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

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


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


    The version is not that important, I would usually recommend to use the latest one, currently 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

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks