Mysql connectivity from POcket pc application using .netcf 2.0

Question

Hi, We are developing an order taking system in PDA using C# in .netcf 2.0. So we are having mysql server as our back end. Is that the web service is the only way to connect mysql with PDA? Or is any other methods available..?

Answer 1

I don't believe there is a Data Provider for MySQL in Compact Framework.

I recommend that you read the Mobile Application Architecture Guide, especially the Data Layer chapter to see what your options are.

Answer 2

There is a .netcf connector on MySql web site available for download. I recommend to use version 5.2.7 and not to forget to put "pooling=false" into the connection string, otherwise connection will fail with exception "MissingManifestResourceException" .

Connection string example: "Persist Security Info=False;database=DATABASE_NAME;server=SERVER_IP_ADDRESS;user id=USERNAME_TO_LOGON;Password=PASSWORD;pooling=false"