-
Title
Error "Input string was not in a correct format" when launching TOAD for DB2. -
Description
When user double clicked on the TOAD for DB2 icon, the message "Input string was not in a correct format" was generated. When the user tried to close the message box by clicking on the X, the error would reappear. The user would have to close the message box three times before TOAD would launch. Upon launching, the error message would be generated one more time. When the user tries to close the last message box, TOAD disappeared.
-
Cause
This is a bug in the .NET version 2.0 framework.
-
Resolution
QUALIFYING THE PROBLEM
1. There is an attachment associated with this solution. Download it and unzip the attachment.
2. Copy the TestApp.exe (located at TestApp\TestApp\bin\Debug) file to the install directory where toad.exe locates. By default TOAD.exe is located in C:\Program Files\Quest Software\Toad for DB2 2.5.
3. Run it and enter number 0 in the "enter an integer" field and parse it. The exception "Input string was not in a correct format" should appear. Looking at the source code will show this is the line that causes the exception
result = Int32.Parse(input);
4. Enter 1 and parse it. This time it should be fine.
5. If entering 0 gives "Input sting was not in a correct format" exception, try the workaround below.
Note: As this is a Microsoft issue, Quest cannot guarantee the following workaround will solve this issue. It has resolved this issue for "some" of our customers in the past.
WORKAROUND 1:
1. Check the release note for TOAD for DB2 to make sure you meet the requirements.
2. Make sure Windows is allowed to update.
3. If all looks good and the issue is not resolved at this point, try WORKAROUND 2.
WORKAROUND 2:
1. Go to Start | Run and type in "regedit."
2. In your registry, go to HKEY_CURRENT_USER | Control Panel | International.
3. In the right panel, open up the key sPositiveSign.
4. In the Value Data field press "delete" a couple of times.
5. Run you TOAD.
Note: Please get permission first from a System Admin because modifying registry settings may have adverse effect on the system. Also, if the above work around does work, it is strongly advised that Microsoft is contacted.WORKAROUND 3:
1. Go to Start|Settings|Control Panel|Regional and Language Options.
2. Change language to English (United Kingdom) (or to "English (United States)" if the language was already set as English UK).
3. Apply changes and Start Toad.
4. Go again to Start|Settings|Control Panel|Regional and Language Options and change the language to the one that was set before.
5. Start Toad again -
Attachments