Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#47 OCI8: Cannot allocate OCI handle

open
nobody
General (41)
5
2009-12-29
2009-12-29
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 3 (Build 2600)
COMCTL32.DLL: 6.0.2900.5512
OCI.DLL: 9.2.0.1.0

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

Discussion

  • randolf_geist
    randolf_geist
    2009-12-29

    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