MYSQL 4.2.18 BUGS

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
wdavet
Posts: 24
Joined: Mon 26 Feb 2007 16:57

MYSQL 4.2.18 BUGS

Post by wdavet » Thu 13 Sep 2007 22:48

Support Team,

I have been holding off upgrading for about 6 months due to the fact that the past upgrades that I have downloaded have always had annoying bugs in them. I finally figured since you are on version 4.2.18 it was probably stable enough to try. I was wrong.

I am using VS 2005 Standard on Vista Ultimate. I have the Service Pack that allows 2005 to run in Vista Ultimate.

When I drag a adapter to a component form and select query builder wizard and select an existing mysql connection, I get the following error.

Unable to cast object to type
'CoreLab.MySql.Design.MySqlDataAdapterDesigner' to type
'CoreLab.Common.Design.DataAdapterEditorForm'.

Alternately if I drag the table into the component adapter it automatically creates a Connection and DataAdapter which allows me to build a query with the query builder wizard. However, when I use the Dataset Wizard
I get the following error.

Data Source assigned to table Table1 not configured.
Either SelectCommand property not set or
SelectCommand.CommandText property not specified.

I noticed that when I finished creating a query in the query wizard the DataAdapter did not create the table mappings as in the previous version.
There are simply no table mappings.

I hope that this can be resolved soon.

Sincerely,

W. David Taylor

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 14 Sep 2007 12:16

Unable to cast object to type 'CoreLab.MySql.Design.MySqlDataAdapterDesigner' to type 'CoreLab.Common.Design.DataAdapterEditorForm'.
Make sure that you don't have assemblies from the old versions of our software on your system.

Other problems are unclear. Could you describe them more detailed? It is desirable that you send me some screenshots showing the steps that you perform.
(Use email address from the Readme.txt file.)

wdavet
Posts: 24
Joined: Mon 26 Feb 2007 16:57

Checking to Make sure old assempblies are not present

Post by wdavet » Fri 14 Sep 2007 13:32

Alexey,

Thanks for the reply.

Regarding old assemblies. I did have version 3.55 on this machine before. I uninstalled it prior to installing version 4.2.18. Is this sufficient or is there something else I should do?

>Quote:
>Unable to cast object to type >'CoreLab.MySql.Design.MySqlDataAdapterDesigner' to type >'CoreLab.Common.Design.DataAdapterEditorForm'.
>Make sure that you don't have assemblies from the old versions of our >software on your system.

I will put together some screen shots of all the errors that I am having and e-mail them to you at the address in the readme.txt file.

Thanks.

W. David Taylor

BTW, as far as I can see your objects seem to be the best way to go if you are connecting to ASP.NET 2.0. They seen to allow someone use them in the same way as ASP.NET 1.1 and also take advantage of some of the newer features of ASP.NET 2.0 sqldatasource objects.

wdavet
Posts: 24
Joined: Mon 26 Feb 2007 16:57

Found Something

Post by wdavet » Fri 14 Sep 2007 14:00

Alexey,

I unistalled all the Corelab stuff using the Add/Remove program tools.

I found a left over assembly in the GAC called CoreLab.DbTools.Vs.Common

I tried to remove it with the GAcUtil and it failed with the following response.

C:\Program Files\Microsoft Visual Studio 8\VC>gacutil -u CoreLab.DbTools.Vs.Common
Microsoft (R) .NET Global Assembly Cache Utility. Version 2.0.50727.42
Copyright (c) Microsoft Corporation. All rights reserved.


Assembly: CoreLab.DbTools.Vs.Common, Version=2.0.49.0, Culture=neutral, PublicKeyToken=09af7300eec23701,
processorArchitecture=MSIL
Unable to uninstall: assembly is required by one or more applications
Pending references:
SCHEME: ID:
Number of assemblies uninstalled = 0
Number of failures = 0

Can you give me instructions as to how to clean this up so that I can attempt a clean install of the newest code?

Thanks.

W. David Taylor

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 14 Sep 2007 14:30

Just delete it using Explorer.

wdavet
Posts: 24
Joined: Mon 26 Feb 2007 16:57

GAC

Post by wdavet » Fri 14 Sep 2007 15:37

Alexey,

It would not delete in explorer. I had to reboot in safe mode to uninstall it.

Anyway, I search the registry and removed any reference to corelab after unistalling MySQL Direct. I reinstalled the 4.2.18 code and still have the same issue.

I am sending a screen shot to you at the e-mail address in the readme file.

I did find out that it seems to work correctly if I drag that table directly from the Database Explorer, but only if I check allow password saving in when I initially create the connection in the Database Explorer.

I does not work if I drag a Connection first and set it up and then drag a DataAdapter and try to select a connection when prompted. That is when I get the error.

Hope this info helps.

Thanks,

W. David Taylor

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Mon 17 Sep 2007 07:20

I haven't received anything from you.
Please resend your letter to me directly (alexeyi at crlab dot com).

wdavet
Posts: 24
Joined: Mon 26 Feb 2007 16:57

Sent you a Screen Shot

Post by wdavet » Tue 18 Sep 2007 02:13

Alexey,

I sent you a screen shot of the error to the e-mail that you provided.

Did you get it?

Thanks

W. David Taylor

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Tue 18 Sep 2007 08:55

I've answered you by email. Please check this out.

wdavet
Posts: 24
Joined: Mon 26 Feb 2007 16:57

MySQL Bugs

Post by wdavet » Tue 18 Sep 2007 15:23

I did not get the e-mail message.

Please try to resend to wdavet at lslink dot com

Thanks,

W. David Taylor

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Wed 19 Sep 2007 07:36

You are developing WebSite project, aren't you?
Could you sent it to me?

wdavet
Posts: 24
Joined: Mon 26 Feb 2007 16:57

Reply

Post by wdavet » Wed 19 Sep 2007 20:37

Alexey,

I still did not get the e-mail that you sent me.

I can create a new sample website and it does the exact same thing.

I will send to you as soon as possible.

Did you find anything out. Is it an issue with VS Standard and/or Vista Ultimate?

Thanks.

W. David Taylor

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 20 Sep 2007 09:09

I can't say for sure, because I've tested on Vista Business.
I will be looking forward to your website.

wdavet
Posts: 24
Joined: Mon 26 Feb 2007 16:57

Web Site that Reproduces Error

Post by wdavet » Thu 20 Sep 2007 18:38

Alexey,

I e-mailed you a sample web project that reproduces this error.

Thanks.

W. David Taylor

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 21 Sep 2007 08:12

I've answered you by email.
Please check the mail.

Post Reply