Making connection between MySQL database and C# Mobile device project

[danbt]

Hi All.

Im having trouble, making a connection between my MySQL database and C# Mobile device project.

I can do it with a normal windows form program using the ODBC Connector. And adding the reference.

However, I cant add the same reference on the mobile device project.

Help would be greatly appreciated.

Thanks;

[danbt]

Anyone, any ideas? Please...

[gokuajmes]

did u ping back at Msdn forums . I am sure it has to do with the Referance to the Sql namespace

[gaylo565]

Your problem is this: with the SDK for mobile devices you have to use the sqlce (compact edition) and the sqlce classes (wich are very similar to those for regular sql.) It is possible to link it to a regular sql db on a computer if you build a sync sort of program but if your db is on the mobile device itself you need to be using sqlce. Hope this helps