Help! I'm getting this message "Unable to Find EntitySpaces.MySqlClientProvider.dll"
It occurs at the following code:

custcol = new CustomersCollection();
custcol.LoadAll();

I have really no idea what's going wrong. The reference to the DLL is right there in VS2005.
Anyone have an idea?

 Here are some details:
 

System.Exception was unhandled
  Message="Unable to Find EntitySpaces.MySqlClientProvider.dll"
  Source="EntitySpaces.LoaderMT"
  StackTrace:
       at EntitySpaces.LoaderMT.esDataProviderFactory.GetDataProvider(String providerName, String providerClass)
       at EntitySpaces.Interfaces.esProviderFactory.GetDataProvider(String providerName, String providerClass)
       at EntitySpaces.Interfaces.esDataProvider.esLoadDataTable(esDataRequest request, esProviderSignature sig)
       at EntitySpaces.Interfaces.esDynamicQuery.Load()
       at EntitySpaces.Core.esEntityCollection.LoadAll()
       at InfraWorks.pnlCustomersGrid.LoadCustomers() in C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\InfraWorks\InfraWorks\Panels\pnlCustomerGrid.cs:line 63
       at InfraWorks.pnlCustomersGrid.pnlCustomers_Load(Object sender, EventArgs e) in C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\InfraWorks\InfraWorks\Panels\pnlCustomerGrid.cs:line 307
       at System.Windows.Forms.UserControl.OnLoad(EventArgs e)
       at System.Windows.Forms.UserControl.OnCreateControl()
       at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
       at System.Windows.Forms.Control.CreateControl()
       at System.Windows.Forms.Control.ControlCollection.Add(Control value)
       at System.Windows.Forms.Form.ControlCollection.Add(Control value)
       at InfraWorks.frmMain.ChangePanel(String key) in C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\InfraWorks\InfraWorks\frmMain.cs:line 122
       at InfraWorks.frmMain.Form1_Load(Object sender, EventArgs e) in C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\InfraWorks\InfraWorks\frmMain.cs:line 40
       at System.Windows.Forms.Form.OnLoad(EventArgs e)
       at System.Windows.Forms.Form.OnCreateControl()
       at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
       at System.Windows.Forms.Control.CreateControl()
       at System.Windows.Forms.Control.WmShowWindow(Message& m)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
       at System.Windows.Forms.ContainerControl.WndProc(Message& m)
       at System.Windows.Forms.Form.WmShowWindow(Message& m)
       at System.Windows.Forms.Form.WndProc(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
       at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)
       at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
       at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
       at System.Windows.Forms.Control.set_Visible(Boolean value)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.Run(Form mainForm)
       at InfraWorks.Program.Main() in C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\InfraWorks\InfraWorks\Program.cs:line 20
       at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
       at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
       at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
       at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading.ThreadHelper.ThreadStart()

I think you have to  download mysql-connector-net-5.1.3

Guys,

Thanks for the answers.

Yes, the MysqlClientProvider was in the bin folder. First thing I checked...
And no, I don't need the .Net connector 5.1.3.
I use version 5.0.8.1 and it works just fine.

But thanks for the replies

Anyway, what was wrong? I don't know. I changed a MSSQL server project to MySQL.
I think somehow VS2005 got all messed up because of the removal of several references (MSSQL) and addition of other references (MySQL).

I changed a whole lot of references, and renewed all the datasources in VS2005 and now everything works again.

But working with databinding in Winforms and changing the database certainly is a recipe for trouble...

But working with databinding in Winforms and changing the database certainly is a recipe for trouble...

I'm suprised it would effect you at all? Technically, you don't even have to include the EntitySpaces DataProvider in your solution, so as long as your database schema as the same it shouldn't have mattered really?