MySQL Bugs: #31771: Cannot conect MySQL in ASP.Net

Bug #31771	Cannot conect MySQL in ASP.Net
Submitted:	23 Oct 2007 2:21	Modified:	21 Feb 2013 20:58
Reporter:	Lenh Ho Xung	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Connector / NET	Severity:	S1 (Critical)
Version:	5.1.3	OS:	Windows (SP2)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
[SocketException (0x273d): The attempted operation is not supported for the type of object referenced]
   System.Net.Sockets.Socket.get_ConnectEx() +293
   System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state) +397
   System.Net.Sockets.Socket.BeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state) +181
   MySql.Data.Common.StreamCreator.CreateSocketStream(IPAddress ip, Boolean unix) +157
   MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout) +333
   MySql.Data.MySqlClient.NativeDriver.Open() +190

[MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.]
   MySql.Data.MySqlClient.NativeDriver.Open() +250
   MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() +61
   MySql.Data.MySqlClient.MySqlPool.GetConnection() +142
   MySql.Data.MySqlClient.MySqlConnection.Open() +306
   _Default.Page_Load(Object sender, EventArgs e) in d:\Temp\WebSite\Default.aspx.cs:19
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

How to repeat:
where does this bug come from?

I was having this particular issue.  I am able to connect using the connector. I have documented the steps I took on http://www.makingyournetwork.com/portal/CIS/tabid/54/forumid/2/scope/threads/Default.aspx

It is a rather long post, so print it out.  The Connector is still a little bit goofy but at least I can see the tables. One note, use a fully qualified table.fieldname in your query specifier.  You cannot accept the default {specify columns from a table or view}  setting because it places [ ] (square brackets)  around the field names and MySQL Server is not happy about their presence. I cannot get the advanced SQL generation options to work.  The update, delete and insert settings are grayed out. Buty you can build your own when you choose option 1). Specify a custom SQL statement or stored procedure.

Seemingly this slipped by me so I apologize.

Lenh, does this represent problem for you still? Even with new c/NET?

Rick, the link is dead. Can you please make text available to others?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Please let us know if this issue is still happening with Connector/Net 6.1+ and if so please provide reproduction steps and a sample project that will show the error.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

propecia or proscar propecia prostate cancer  <a href=http://buypropeciaonline371.posterous.com>buy propecia online</a> propecia women side effects propecia reviews