cstephen100
asked on
windows mobile mysql db
Hi
I am going to be developing programs using windows mombile hand helds. The program will be synchronised with a mysql database on the main system.
Is there a MySql db veriosn for handhelds? or is there other db that can be used. Im conscious of the differnent sql standards.
Thanks
Stephen
I am going to be developing programs using windows mombile hand helds. The program will be synchronised with a mysql database on the main system.
Is there a MySql db veriosn for handhelds? or is there other db that can be used. Im conscious of the differnent sql standards.
Thanks
Stephen
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There is no MySQl for Windows mobile but you can connect to a remote MySql database
ASKER
Hi Guys
If you connect to a remote Mysql database how can you update or run the apps on the hand helds.
I.e Client want to view service calls, scan a serial number and post call as complete. He needs the info available to him offline (when not connected to head office).
I know sql server has tool for doing it as shown above.
Thanks
Stephen
If you connect to a remote Mysql database how can you update or run the apps on the hand helds.
I.e Client want to view service calls, scan a serial number and post call as complete. He needs the info available to him offline (when not connected to head office).
I know sql server has tool for doing it as shown above.
Thanks
Stephen
you would have to make a Web Service running on the sever and create methods for each action. InsertData()
After you create the methods then it will be exposed on the handheld which you can then update and do whatever with your MySql db
After you create the methods then it will be exposed on the handheld which you can then update and do whatever with your MySql db
ASKER
thanks mikal for reply,
That sounds fine, however, if i want to view the data on the handheld when im not connected to the server in hq? Will i need to have db on hand held that stores all data?
Thanks again
stephen
That sounds fine, however, if i want to view the data on the handheld when im not connected to the server in hq? Will i need to have db on hand held that stores all data?
Thanks again
stephen
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That is very intresting surely, only thing our application has a MySql database. Im not sure if this sync will work then?
Thanks
Stephen