Re: SqlDataSource and .NET Connector 5.0.2 Beta
Posted by:
Danny Park
Date: November 07, 2006 10:31AM
I've tried many different connection strings. Some examples are below.
"user=myusername;"
"server=localhost;user=myusername;password=mypassword;database=mydatabase;"
"user=myusername;password=mypassword;"
I always get the same error (Input string was not in a correct format).
I am including the stack trace below just in case that helps. The error comes when I call myConnection.Open();
[FormatException: Input string was not in a correct format.]
System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +2752899
System.Number.ParseInt64(String value, NumberStyles options, NumberFormatInfo numfmt) +112
MySql.Data.Types.MySqlInt64.MySql.Data.Types.IMySqlValue.ReadValue(MySqlStream stream, Int64 length, Boolean nullVal) +208
MySql.Data.MySqlClient.NativeDriver.ReadColumnValue(Int32 index, MySqlField field, IMySqlValue valObject) +105
MySql.Data.MySqlClient.MySqlDataReader.Read() +181
MySql.Data.MySqlClient.Driver.LoadCharacterSets() +333
MySql.Data.MySqlClient.Driver.Configure(MySqlConnection connection) +326
MySql.Data.MySqlClient.NativeDriver.Configure(MySqlConnection connection) +10
MySql.Data.MySqlClient.MySqlConnection.Open() +276
TestDatabase.Page_Load(Object sender, EventArgs e) in c:\creativeworks.byu.edu\Test\TestDatabase.aspx.cs:23
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +13
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +45
System.Web.UI.Control.OnLoad(EventArgs e) +80
System.Web.UI.Control.LoadRecursive() +49
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3743