I have just downloaded the v2.0 demo. When I try to connect to a mySQL database in the "Create New Project" all I get is:

Could not load file or assembly 'CoreLab.MySql, Version=3.55.22.0, Culture=neutral, PublicKeyToken=09af7300eec23701' or one of its dependencies. The system cannot find the file specified.

-----[Core exception]--------------------
   at SD.LLBLGen.Pro.DBDrivers.MySql.MySqlConnectionData._testConnectionButton_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.Button.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.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Source
SD.LLBLGen.Pro.DBDrivers.MySqlDBDriver

Does llblgenpro v2 support MySQL out of the box? If so what can I do to get around this problem?

Help!

Do you have CoreLab driver?

Quoted from the manual:

Required for MySql: CoreLab's MySqlDirect.NET provider v3.55.x or v4.x (v3.55.x has its own driver dll, please copy the driver dll from the Drivers\MySql\v355 folder into the MySql folder overwriting the v4 using driver).

Also check the following similar questions: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=3960 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=9718 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7583

Many thanks (I couldn't find the answer ).

To clarify for anyone else reading this later:

To use llblgenpro with MySQL (not my choice) you also need to purchase mySQLDirect.NET Data Provider from Corelabs http://www.crlab.com

like2175 wrote:

Many thanks (I couldn't find the answer ).

To clarify for anyone else reading this later:

To use llblgenpro with MySQL (not my choice) you also need to purchase mySQLDirect.NET Data Provider from Corelabs http://www.crlab.com

I've now downloaded mySQLDirect.NET Data Provider v4.0 from Corelabs and get:

Could not load file or assembly 'CoreLab.MySql, Version=4.0.9.0, Culture=neutral, PublicKeyToken=09af7300eec23701' or one of its dependencies. The system cannot find the file specified.

-----[Core exception]-------------------- at SD.LLBLGen.Pro.DBDrivers.MySql.MySqlConnectionData._testConnectionButton_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.Button.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.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

SD.LLBLGen.Pro.DBDrivers.MySqlDBDriver

any suggestions?

Most probably you need an assembly re-direction to be placed in the application config file.

Please check the GAC to see if you have CoreLab.MySql.dll in there, please post its version as seen in the GAC.

Also see if there are any publisher policy files registered in the GAC.

gacutils /l reports:

CoreLab.Data, Version=4.0.9.0, Culture=neutral, PublicKeyToken=09af7300eec23701, processorArchitecture=MSIL
CoreLab.Data.Design, Version=4.0.9.0, Culture=neutral, PublicKeyToken=09af7300eec23701, processorArchitecture=MSIL
CoreLab.DbTools.Vs.Common, Version=2.0.45.0, Culture=neutral, PublicKeyToken=09af7300eec23701, processorArchitecture=MSIL
CoreLab.MySql, Version=4.0.10.0, Culture=neutral, PublicKeyToken=09af7300eec23701, processorArchitecture=MSIL
CoreLab.MySql.Web, Version=4.0.10.0, Culture=neutral, PublicKeyToken=09af7300eec23701, processorArchitecture=MSIL

Is this the information you wanted?

How do I

see if there are any publisher policy files registered in the GAC.

The application requests version 4.0.9.0 while you have version 4.0.10.0.

Try to use the following assembly re-direction in the config file.

<runtime> <dependentAssembly> <assemblyIdentity name="CoreLab.MySql" publicKeyToken="09af7300eec23701" culture="neutral" /> <bindingRedirect oldVersion="4.0.9.0" newVersion="4.0.10.0"/> </dependentAssembly> </runtime>

I've learnt (a bit) about GAC Policies....

I've added entries for v4.0.9.0 to v4.0.10.0 for Corelab.Mysql and Corelab.MySql.Web...

Now when I "test connection" I get:

 Error: License not valid.Please view "Licensing" topic in MySQLDirect.NET documentation for details or 
contact Core Lab technical support.
   at CoreLab.MySql.MySqlConnection  Open  ()
   at SLLBLGen .Pro.DBDrivers MySql .MySqlConnectionData  ._testConnectionButton _Clic(Object sender ,EventArgs e 

Please contact corelab about this: they have to provide a valid policy file and also their licensing should work properly. This is unfortunately out of our hands. They have to provide a proper policy file and the licensing should work normally. Please mention this thread to them as well. I'll also mail them about this and refer to this thread.

Is there another way to connect to MySql with Llbl without the @&^@&#% Corelab provider?

I am having the same trouble

Corelab has recognized these problems and is working on a fix.

Corelab has provided a fix for this, by supplying a special file which we embedded in our .exe. The assembly redirects will be fixed in their new build of the provider, our new build of the designer (released later today) will be able to use their trial properly.