Usefull free software

Avast antivirus
http://www.avast.com/index

Super Anti Spyware
http://www.superantispyware.com/

Microsoft AppLocale Utility – Microsoft AppLocale is a utility that allows Unicode (UTF-16) based Windows XP and 2003 users to run non-Unicode legacy (code-page based) applications without changing the current system locale. AppLocale automatically detects language for non-Unicode program and simulates a corresponding system locale for code-page to/from Unicode conversions.
Download 

Sandboxie
http://www.sandboxie.com/

Debugging Oracle PL/SQL procedures using SQL Developer

1. Start SQL Developer and connect to DBMS.
2. Grant:
GRANT DEBUG CONNECT SESSION TO some_user;
GRANT DEBUG ANY PROCEDURE TO some_user;
3. Start remote debug, enter Port and IP address which is accessible from DBMS.
4. Execute “execute DBMS_DEBUG_JDWP.CONNECT_TCP(‘your ip’,4000);”.
5. Select procedure, add breakpoint, compile for debug.
6. debug procedure (ctrl+shif+f10), enter IP if needed.


	

PowerBuilder 8 OLE insert crash

I had same work with an old PowerBuilder 8 application maintenance and upgrade. While trying to add OLE control to a windows PB constantly crashed. PB and Windows XP reinstall didn’t helped. I found a hint here http://brucearmstrong.wordpress.com/2007/07/10/problems-using-activex-controls/

In short:
1. Download Process Monitor
2. Add filter to pb80.exe process and path that begins with HKCR\CLSID
3. Try to add OLE with PB (make it crash)
4. Find last entry that ends with Control, search this CLSID with regedit
5. Reregister dll You found.
In my case it was regsvr32 %systemroot%\system32\mstscax.dll
Problem solved.