MYSQL

Question

i am using VS2005 now. i am doing on a project that requires me to connect pocket PC with MYSQL but i dont know the exact steps to do so. can anyone help?

Answer 1

Hi,

 

Out of the box the .NET Compact Framework does not support this. What you need to do is find an ADO.NET Data Provider for MYSQL which works with the .NET Compact Framework.

 

MYSQL is not a database I have used within the .NET enivronment in the past so I am not aware of possible solutions here. A quick web search turned up a third party selling a product called "MySQLDirect.NET" which seems to support the .NET Compact Framework (see http://www.crlab.com/mysqlnet/), there may be other options.

 

Depending upon your needs, and architectural design decisions, you may find it easier to access your MYSQL database on your desktop PC and wrap up access to it via an ASP.NET Webservice. The Pocket PC device could then use a web service proxy to communicate with the web service, which would then perform the database queries on it's behalf.

 

Hope this helps,

Christopher Fairbairn

Answer 2

Exact steps depend on 3rd party MySQL provider you've purchased. There's nothing in NETCF to connect to any database but SQL Server and SQL CE.

 

Answer 3

We are having a website which runs MySQLDirect with .Net 1.0 and MySQL 4.0 properly.

 

After  i upgraded my database to MySQL 5.0  , my webpages could not able to access the database and,

gives the following error,

 

Lost connection to MySQL server during query

or

 

Net packets out of order: received[3], expected[1]

 

 

Kindly give me a valuable suggestion to make it work.

 

Answer 4

Hi,

 

I think you've posted in the wrong forum. Since this forum is dedicated to development for smart devices (such as Windows Mobile PDAs) you may have better luck asking this question within an ASP.NET or MYSQL related forum (such as http://forums.asp.net/).

 

Also in the future try not to post new questions at the bottom of an existing thread, especially a thread you didn't create. This can be counter-productive to getting an answer, as many people (such as myself) will search for unanswered threads and won't find this question due to the original question within the thread having been marked as answered.

 

Hope this helps,

Christopher Fairbairn

Answer 5

 

Sorry Christpher , i will make it correct. thanks for the help.