Page 1 of 1

Error when creating dataset using create dataset wizard

Posted: Wed 20 Feb 2008 05:43
by sportsoft
Hi There

Please help very urgent (aren't they all)

We have been using mydirect 3.55 for quite some time now with out any real problems.

Upgraded to 4.30 due to the streaming capabilites now available with mysqldump as our databases a quite large. This all works fine in the new version.

I un installed the old version, and reinstalled 4.30, updated the references in VS to the new version and tested to make sure that the existing projects worked and they all do.

I tried however to create a new form with a new connection, dataadapter and then from the dataadapter use the dataset creation wizard (just as we always did with the previous version). It creates the dataset, but the dataset has the following errors:

Code: Select all

Error	42	Value of type 'CoreLab.MySql.MySqlConnection' cannot be converted to 'CoreLab.MySql.MySqlDataTable'.	C:\Development\Indoor System\Vb Apps\Indoor Server Version\DataSet_player_membership1.Designer.vb	281	52	Indoor Sports System
One for each data table

Code:

Code: Select all

Me.tablegame_type = New game_typeDataTable(Me.Connection)
The "me.connection" is a connection type and it requires a datatable type.

So as it doesnt require a parameter, I removed it and the errors went, but then the dataset is corrupted and it causes many many problems including VS to totally freeze.

I really need help with this issue as we have to fix some major bugs that require this feature to function correctly.

Nick

Posted: Thu 21 Feb 2008 11:36
by Alexey.mdr
Please make a completely new WinForms project.
Run the DataSet wizard (create a new connection, use provider-specific code generator).
If you need your DataSet get filled by other than auto generated MySqlDataAdapter,
drag-and-drop a new MySqlDataAdapter. Specify the SELECT statement and the connection.
Try filling your new DataSet with the new adapter.
Do you still receive the error?

Works, but how do I move forward

Posted: Mon 25 Feb 2008 10:09
by sportsoft
Thanks for the reply.

That did fix the problem, but it really doest offer me a solution to the situation. Our project has hundreds of refences to the 3.55 version.

So how can we move forward with this project?

Nick

Posted: Mon 25 Feb 2008 16:08
by Alexey.mdr
If you would like to move to version 4.30,
correspondingly change all the references in your .csproj files.
It should not be very difficult.

Still not working

Posted: Thu 28 Feb 2008 00:49
by sportsoft
I Have changed all the references in the project to the 4.3 version and still exactly the same problem.

Posted: Thu 28 Feb 2008 15:34
by Alexey.mdr
I assume the problem is not in the version.
As MyDirect .NET installs policy files into GAC.
Please send me a small test project to reproduce the problem.
It is desirable to use 'test' schema objects, otherwise include the
definition of your own database objects.
Do not use third party components.
If it is impossible for you to create the test project, send us a piece of
your code where the error occurs.