Thursday, June 5, 2014

sql5005n: Unable to init API env

When I try to import a DB2 catalog to Toad for db2 4.7, I got sql5005n: Unable to init API env error. Database alias combo is not populated. This happens with 64 bit toad whereas 32 bit version is working fine. I had this problem under windows 8.1. Solution: Forget catalog import on toad. Run all below steps with administrator right 1. Install db2 64 bit client to windows. 2. Install Toad 64 bit 3. Edit registry , change HKLM\Software\Wow6432Node\QuestSoftware\Toad For DB2\4.7\DB2COPY key to DB2COPY1 (initial repository for IBM client) 4. Run IBM DB2 configuration assistant 5. Import catalog by using configuration assistant 6. Run toad, database alias combo is populated.

Monday, May 19, 2014

Visual WebGUI undefined error

After you have developed your visual webgui form and pressed run, if all you get is "undefined" on the internet browser; Your new form class is not in the same namespace as your original application.

Sunday, May 18, 2014

SQL Server Management Studio Performance Issues

I work on VMWare Workstation 9.0 hosted Windows 2008 R2 Server. When I open Sql Server Management Studio, I experience sluggish performance while editing stored procedures. At that times I observe ssms.exe is hogging the cpu. Even a simple screen scroll causes %50 cpu spikes. I've tried patching SQL Server and VMWare but no avail. I also tried suggested solutions like disabling SVGA driver etc. As a solution, I logoff VMWare console and connect to server instance with remote desktop. No performance issue...

Thursday, October 10, 2013

Google mail IMAP Error

Hi, This is my first post.
My employer uses gmail as corporate email. I access to gmail IMAP servers from my PC and mobile. In the last a few days I started getting Too many simultaneous IMAP connections  error from both devices.
Gmail IMAP server has a limitation like max. 10 connections. But how come my email clients can open so many connections?
I first suspected that someone hacked my email account and changed my email password.  No solution. Then I've searched the web and found this useful post
http://productforums.google.com/forum/#!topic/gmail/0bRLzEjec-M

Checked my gmail with web browser and seen that my mobile device email client has created multiple sessions. How come?  My cell phone connects to internet with wifi or 3g whichever is available. In the last a few days the wifi had some problems. So the cell phone keeps changing the IP address between 3g and wifi. For each new IP, email client creates a new connection so the limit of IMAP is reached.
The solution: I have disabled the wifi on the mobile until it's permanently fixed.