Conn Details BLOWS UP

[GoogleCodeExporter]

What steps will reproduce the problem?
1.Click Edit Connection
2.Change Connection Information to Something invalid (I changed TCP to TC)
3.Save Connection
4.Stuff Blows Up

What is the expected output? What do you see instead?
ANYTHING ELSE OTHER THAN THAT.

Please use labels and text to provide additional information.

Original issue reported on code.google.com by Spoofed...@gmail.com on 1 Apr 2010 at 1:29

[GoogleCodeExporter]

Server Error in '/' Application.
Input string was not in a correct format.
Description: An unhandled exception occurred during the execution of the 
current web
request. Please review the stack trace for more information about the error and 
where
it originated in the code.

Exception Details: System.FormatException: Input string was not in a correct 
format.

Source Error:

Line 2371:            try
Line 2372:            {
Line 2373:                DB.executeQueryLocal("UPDATE Connection SET name=\'" 
+ connName
Line 2374:                    + "\', dbName=\'" + connDBName
Line 2375:                    + "\', userName=\'" + connUser

Source File: C:\Documents and Settings\David\My
Documents\ODBC2KML\hci\HCI\ConnDetails.aspx.cs    Line: 2373

Stack Trace:

[FormatException: Input string was not in a correct format.]
   System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer&
number, NumberFormatInfo info, Boolean parseDecimal) +7469351
   System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +119
   System.Convert.ToInt32(String value) +63
   HCI.ConnDetails.saveConnInfo() in C:\Documents and Settings\David\My
Documents\ODBC2KML\hci\HCI\ConnDetails.aspx.cs:2373
   HCI.ConnDetails.modifyConnection(Object sender, EventArgs e) in C:\Documents and
Settings\David\My Documents\ODBC2KML\hci\HCI\ConnDetails.aspx.cs:2360
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBa
ckEvent(String
eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String
eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
Boolean includeStagesAfterAsyncPoint) +1565

Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET
Version:2.0.50727.3082 

Original comment by Spoofed...@gmail.com on 1 Apr 2010 at 1:46

[GoogleCodeExporter]

So this is a 2 part problem.  The "Update" or "Connect" button should verify db 
connection information but the Save Connection button should as well.

Original comment by nind...@gmail.com on 1 Apr 2010 at 2:14

[GoogleCodeExporter]

This issue was closed by revision r371.

Original comment by jpetti...@gmail.com on 1 Apr 2010 at 5:59

• Changed state: Fixed

[GoogleCodeExporter]

Verified no longer explosive.

Original comment by sweenr...@gmail.com on 1 Apr 2010 at 6:15

• Changed state: Verified