using our office Local Area Network (192.168.1.xxx), I have no problem with the client updating the server database, when I set the MySqlConnection string "server=IP_Addresses_of_Server".
However, when I switch to GPRS Connection with Private APN (Access Point Name) and Static IP addresses, the update of server database fail. It has static IP addresses as (203.117.249.xxx). I just change the MySqlConnection string "server=203.117.249.xxx;database=productcatalog;uid=root;password=12345678"
thanks.
1 answers
Hi Vulpes
I am confused about it. With our office LAN, and with the timers which constantly update the client from the server database, the whole program runs smoothly. When it comes to using GPRS, with the same program with the timers, the whole program hangs. But when I remove those timers, the program works ok with GPRS. I do not know what are the causes which include the timers, that using GPRS connection, the whole program get hangs and not working. I would still need the timers, as I would need the server database to update the clients.
thanks.
answered one year ago by:
494
17279
It may be that, due to the relative slowness of the GPRS connection, the timers are causing some database commands to 'time out' and to hang the program. Would it be feasible to simply disable the timers when using a GPRS connection or (though it might mean duplicating code) to have two different methods - one for the office LAN and the other for GPRS?
494
thanks for your comment. I got to check that out, whether relative slowness of GPRS connection could be the cause. in our actual deployment, I would need GPRS, not LAN.