Bug #40822 Mysql can not connect through .net framework 2.0 with visual studio 2005
Submitted: 18 Nov 2008 13:36 Modified: 19 Dec 2008 9:37
Reporter: shahul hameed Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:5.1.7 OS:Windows
Assigned to: Assigned Account CPU Architecture:Any

[18 Nov 2008 13:36] shahul hameed
Description:
Mysql can not connect through .net framework 2.0 with visual studio 2005

i did everything correctly it used to connect with visual studio 2003 with .net 1.1 but when i tried with .net 2.0 with vs 2005 it throws an exception that "unable to connect any of the specified mysql host" when i open the connection

How to repeat:
Mysql can not connect through .net framework 2.0 with visual studio 2005

i did everything correctly it used to connect with visual studio 2003 with .net 1.1 but when i tried with .net 2.0 with vs 2005 it throws an exception that "unable to connect any of the specified mysql host" when i open the connection
[19 Nov 2008 6:03] shahul hameed
Dim strin As String = System.Configuration.ConfigurationManager.ConnectionStrings("connectionstring").ToString
        Dim sqlConn As New MySqlConnection
        sqlConn.ConnectionString = strin
        Dim sqlCmd As New MySqlCommand
        Dim strSql As String
        strSql = "insert into test(text)values('" & txtUserID.Value & "')"
        sqlCmd.CommandText = strSql
        sqlConn.Open()
        sqlCmd.ExecuteNonQuery()
        sqlConn.Close()
[19 Nov 2008 6:03] shahul hameed
please any one help me on this
[19 Nov 2008 9:37] Tonci Grgin
Hi Shahul and thanks for your report. Alas, it is entirely not sufficient for me to start doing anything.
Are you by any chance using Express edition of VS? If so, it does not
support plug-ins. There is also a TableEditor project which you can use as starting point and reference.

Now, with so many people using c/NET with VS2005 for years (myself included) I must conclude there's something wrong in your environment. Please recheck everything (VS version, NET 2.0 FW config ...) and get back to me.
You may also look into bugsdb and our forums in search for answer.
[19 Nov 2008 9:42] Tonci Grgin
Maybe the best approach would be to:
  o Use Visual Studio Package Load Analyzer (a utility that analyzes package load failures in Visual Studio 2005) to check if c/NET plug-in is loaded.
  o Use test projects available with c/NET to see correct way of doing things.
[19 Nov 2008 9:43] Tonci Grgin
Probably related to Bug#29483.
[20 Dec 2008 0:00] Bugs System
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".