I am using VS 2008 (from a Delphi background).
I need to store data on a win mobile device then upload and download over 3G / wifi.
A few questions please.
1. Does the component create a mysql compatible databse on the device for storage.
2. If not how is the local data stored.
3. Can images be uploaded to blob fields.
4. What are the mechanics for dropping of signal. Ie if a blob field is being updated and the connection lost is it the component that handles the problem.
5. Any other issues with this approach.
6. We are stuck with mysql & images in blob fields.
7. Any simple c# .net cf examples for a simpleton.
Any info appreciated.
Working on windows mobile
We recommend you to try dotConnect for MySQL Mobile Edition. Its trial version (free use during 30 days) is available at http://www.devart.com/dotconnect/mysql/download.html.
Here are the answers to your questions:
1. dotConnect for MySQL Mobile doesn't create any databases. It establishes connection via network (e.g., WiFi) to the database that is installed on your desktop machine.
2. Data is stored at the remote database.
3. Yes, they can. dotConnect for MySQL Mobile includes MySqlBlob class that represents a variable-length stream of binary data to be stored in or retrieved from a database.
4. If connection is lost, you can its state this with the MySqlConnection.Ping() method and reopen it if necessary.
5. and 6. Please specify the problem more exactly.
7. Samples are available in the description of the corresponding class in documentation and in the \Program Files\Devart\dotConnect Mobile\MySQL\Samples\ folder (default path of installation).
You should use some synchronization tool (e.g. ActiveSync, Windows Mobile Device Center, etc) to synchronise your mobile device (or emulator) with a desktop computer.
Notify us about the results.
Here are the answers to your questions:
1. dotConnect for MySQL Mobile doesn't create any databases. It establishes connection via network (e.g., WiFi) to the database that is installed on your desktop machine.
2. Data is stored at the remote database.
3. Yes, they can. dotConnect for MySQL Mobile includes MySqlBlob class that represents a variable-length stream of binary data to be stored in or retrieved from a database.
4. If connection is lost, you can its state this with the MySqlConnection.Ping() method and reopen it if necessary.
5. and 6. Please specify the problem more exactly.
7. Samples are available in the description of the corresponding class in documentation and in the \Program Files\Devart\dotConnect Mobile\MySQL\Samples\ folder (default path of installation).
You should use some synchronization tool (e.g. ActiveSync, Windows Mobile Device Center, etc) to synchronise your mobile device (or emulator) with a desktop computer.
Notify us about the results.