Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Designer> Problem connecting v2 demo to mySQL v5.0
 

Pages: 1
Designer
Problem connecting v2 demo to mySQL v5.0
Page:1/1 

  Print all messages in this thread  
Poster Message
like2175
User



Location:
Camberley, United Kingdom
Joined on:
27-Mar-2006 16:16:06
Posted:
83 posts
# Posted on: 13-Jun-2007 13:50:29.  
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:

Code:
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!
  Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
14639 posts
# Posted on: 13-Jun-2007 15:17:59.  
Do you have CoreLab driver?

Quoted from the manual:
Quote:
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


  Top
like2175
User



Location:
Camberley, United Kingdom
Joined on:
27-Mar-2006 16:16:06
Posted:
83 posts
# Posted on: 13-Jun-2007 15:41:56.  
Many thanks (I couldn't find the answerEmbarrassed).

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

  Top
like2175
User



Location:
Camberley, United Kingdom
Joined on:
27-Mar-2006 16:16:06
Posted:
83 posts
# Posted on: 13-Jun-2007 16:20:39.  
like2175 wrote:
Many thanks (I couldn't find the answerEmbarrassed).

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:

Quote:
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?



  Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
14639 posts
# Posted on: 13-Jun-2007 16:48:08.  
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.
  Top
like2175
User



Location:
Camberley, United Kingdom
Joined on:
27-Mar-2006 16:16:06
Posted:
83 posts
# Posted on: 13-Jun-2007 17:02:55.  
gacutils /l reports:

Code:
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
Quote:
see if there are any publisher policy files registered in the GAC.


  Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
14639 posts
# Posted on: 13-Jun-2007 17:30:34.  
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>
  Top
like2175
User



Location:
Camberley, United Kingdom
Joined on:
27-Mar-2006 16:16:06
Posted:
83 posts
# Posted on: 13-Jun-2007 17:42:31.  
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:
Code:
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



Sad


  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
38092 posts
# Posted on: 13-Jun-2007 21:19:47.  
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.
Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
gustavoc
User



Location:

Joined on:
13-Jun-2007 16:10:28
Posted:
3 posts
# Posted on: 15-Jun-2007 04:30:17.  
Is there another way to connect to MySql with Llbl without the @&^@&#% Corelab provider?

I am having the same trouble


  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
38092 posts
# Posted on: 15-Jun-2007 08:56:46.  
Corelab has recognized these problems and is working on a fix.

Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
38092 posts
# Posted on: 18-Jun-2007 12:36:23.  
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.

Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.