After installing SQLTools++, I first got an error that the OCI.dll file could not be found. After gogling, I downloaded the instantclient - Basic package from oracle.com (v.11.2.0.1.0), and copied the OCI.dll file included there into my C:\Windows\System32 folder. Now, when I try and launch SQLTools++, I get the following:
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: 11.2.0.1.0 Production
Stack at the catch point:
0x7c90e514 KiFastSystemCallRet() + 0
What can I do to fix this problem? Any help would be greatly appreciated. Thanks.
You are almost there... Just remove the OCI.DLL from your Windows folder and create a link to the SQLTools.exe that has the "Start In" property set to the directory where you've extracted the InstantClient to - this way the complete InstantClient will be found.
Alternatively you can simply add the "InstantClient" directory to your PATH.
Randolf