MySQL Bugs: #60322: MissingManifestResourceException exception on Compact Framework

Bug #60322	MissingManifestResourceException exception on Compact Framework
Submitted:	3 Mar 2011 20:38	Modified:	9 Feb 2012 17:57
Reporter:	Maxim Nikolaev	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S4 (Feature request)
Version:	6.3.6	OS:	Windows
Assigned to:	Gabriela Martinez Sanchez	CPU Architecture:	Any
Tags:	MissingManifestResourceException

Description:
I am developing smart device based application in C# using .NET compact Framework. 
While i am trying to open a connection using Mysql Connector  
its throwing exception like 
"MissingManifestResourceException"

Complete exception details:
System.Resources.MissingManifestResourceException was unhandled
  Message="MissingManifestResourceException"
  StackTrace:
       at System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents)
       at System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents)
       at System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents)
       at System.Resources.ResourceManager.GetString(String name, CultureInfo culture)
       at MySql.Data.MySqlClient.Properties.Resources.get_UnableToConnectToHost()
       at MySql.Data.MySqlClient.NativeDriver.Open()
       at MySql.Data.MySqlClient.Driver.Open()
       at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
       at MySql.Data.MySqlClient.MySqlConnection.Open()
       at ControlMobileScan20.Form1.DBConnect()
       at ControlMobileScan20.Form1.button1_Click(Object sender, EventArgs e)
       at System.Windows.Forms.Control.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnClick(EventArgs e)
       at System.Windows.Forms.ButtonBase.WnProc(WM wm, Int32 wParam, Int32 lParam)
       at System.Windows.Forms.Control._InternalWnProc(WM wm, Int32 wParam, Int32 lParam)
       at Microsoft.AGL.Forms.EVL.EnterMainLoop(IntPtr hwnMain)
       at System.Windows.Forms.Application.Run(Form fm)
       at ControlMobileScan20.Program.Main()
 
This error happening both at device and also at emulator.
I tried it with VS2008 SP1 and target .NET 2.0 and .NET 3.5 SP1 frameworks with same result.

How to repeat:
Create in VS2008 smart device application project;
Make a reference to MySQL connector 6.3.6;
Create a button and put a code into onClick handler (i'm using port 3307 for MySQL server, but standard one is of course 3306):

MySqlConnection con = new MySqlConnection("DATABASE=database;SERVER=192.168.0.1;UID=root;PASSWORD=password;PORT=3307;pooling=false");
con.Open();

Sample project which produces this error message

Attachment: CFConSample.rar (application/octet-stream, text), 130.96 KiB.

Looks like it can be just named as "MissingManifestResourceException",
because during testing with sources of MySQL .NET Connector -
it was possible to see that it's hanging in procedure

---(StreamCreator.cs)---

private Stream CreateSocketStream(IPAddress ip, bool unix)
{
 EndPoint endPoint;
#if !CF
if (!Platform.IsWindows() && unix)
	endPoint = CreateUnixEndPoint(hostList);
else
#endif
    endPoint = new IPEndPoint(ip, (int)port);

Socket socket = unix ?
 new Socket(AddressFamily.Unix, SocketType.Stream, ProtocolType.IP) :
 new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
  if (keepalive > 0)
  {
    SetKeepAlive(socket, keepalive);
  }
   IAsyncResult ias = socket.BeginConnect(endPoint, null, null);
   if (!ias.AsyncWaitHandle.WaitOne((int)timeOut * 1000, false))
   {
	socket.Close();
	return null;
   }
   try
   {
	socket.EndConnect(ias); // <--- ERROR HAPPENING HERE
   }
   catch (Exception)
   {
	socket.Close();
                throw;
    }
    MyNetworkStream stream = new MyNetworkStream(socket, true);
    GC.SuppressFinalize(socket);
    GC.SuppressFinalize(stream);
    return stream;
}

I decreased the level of this issue - because the problem was solved - this was just an issue of network connection, which was not connected to MySQL connector itself. Now when network is ok - connector works fine.

However, it was just look like a bug, because of this strange message "MissingManifestResourceException" - this message was not very descriptive in fact.

So this topic can be closed.

Maxim,

Thanks for your comments and for the test case.
MissingManifestResourceException is coming from the following code:

public static string UnableToConnectToHost {
  get {
    return ResourceManager.GetString("UnableToConnectToHost", resourceCulture);
  }
}

The driver cannot connect to the host and it is about to return UnableToConnectToHost error, but ResourceManager cannot find the appropriate string.

Setting to Verified because the error message is misleading and not adequate to the actual error.

Maxim, 

I used the application you attached to the bug entry and I was able to reproduce the issue. I noticed that you're using version 6.3.6 which is the one that has the bug and also it's not longer supported. So I changed to 6.3.8 which doesn't have this issue. And the result is accurate to the error when the connection fails: Unable to connect to any of the specified MySQL hosts. So my recommendation here is to update your application to use this newer version instead of the 6.3.6. which you can download from http://dev.mysql.com/downloads/connector/net/6.3.html#downloads.

Please let us know if this resolve the issue.