SourceForge has been redesigned. Learn more.
Close

#37 OCI8: Cannot allocate OCI handle.

closed
nobody
None
5
2009-08-19
2009-06-17
Anonymous
No

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:
0x7c90e514 KiFastSystemCallRet() + 0

Discussion

  • randolf_geist

    randolf_geist - 2009-06-17

    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-08-19
    • status: open --> closed
     

Log in to post a comment.