I have problem to connect to my mysql server. The connection is fine, I can see the database in server explorer in visual studio.

But when I want to make a dataadapter to use database I get problem. Im using the wizard to create the adapter. Selecting wich tabeles to use works fine, but when I press next to let the wizard generate select, insert, delete and update commands I get the error.

"ERROR [HY010] [MySQL][MyODBC 5.00.10] column count unknown at this time"

Why do i get this error? what does it mean?

I have tried to make new project just to see that it isnt my code. and I have created new simple databases to see that it isnt the problem but no success.

Does anyone know a solution for this I will be more than happy.