Mobile Application

[rothj0hn]

hi guyz.. im developing a Mobile Point of Sale system.. The concept is im using VB 2008 as my Back End and a mobile device (PDA) as my front end.. System flow like this.. what i want to do is i will pass my database records from my back end which is SQL 2000 to the PDA database then the PDA will process the data after the processing the data from PDA database will be transfer again to my back end database..

Desktop Application upload to PDA -- Process in PDA -- Download to Desktop APplication1

________
Free Themes

[rothj0hn]

please give me ideas and technique on how to do this..
________
Vapolution

[Shaggy Hiker]

Is there a question here?

[si_the_geek]

Thread moved to '.NET > Mobile Development' forum

[rothj0hn]

i forgot to include my question.. sorry for that.. i just want to know how to do this.. right now im using text files to pass data from one database to another.. is there any other way?
________
Marijuana vaporizer

[Shaggy Hiker]

Ah, you crossed me up.

How will the PDA interface with the base station? Will you be putting it in a cradle using ActiveSynch? If so, I have done something like this using TCP, but it was for 2003, and much has changed since then. Another alternative, that has only become available relatively recently, is to use WCF. I'm not certain that WCF is available in the mobile CF, but if it is, it would be a relatively versatile solution. The BackEnd would expose a Web Service (I think even the name has changed from Web Service, but that's a good starting point) that you would then discover when using Add Service Reference in the mobile project. Of course, that depends on WCF being available to the CF. That WCF route would also work with TCP, as WCF is just a wrapper for a variety of different communication protocols.

[rothj0hn]

the PDA will be synchronized directly to the desktop computer. im not planning to use any web server..
________
Jaguar xj220

[petevick]

Hi,
sounds ideal for Replication as we have been discussing at length in another thread.

There is a 'step-by-step' article here and an article I wrote on the device side here

Replication can be awkward to set up - but pays dividends in its ease of use when set up correctly.

[rothj0hn]

does replication works in sql server 2000?
________
Cesare Fiorio

[petevick]

Yep - it just doesn't work as a publisher in the express versions

[rothj0hn]

is there other way without using HTTP connection?
________
VAPOLUTION VAPORIZER

[petevick]

That is the way replication (and RDA) works - using IIS server

[rothj0hn]

so if i dont use IIS i wont also be able to use sql replication? my problem is that what im developing is PDA application and Gateway (connection to my PDA and Desktop) only.. I cant change or modify the desktop application..

the process is the desktop just give me text files and then my gateway process this text files and insert it to a SDF. thats on the upload process..
________
Ford Strike Of 1945

[petevick]

So if you can't change the way the application works, why ask the questions?

[rothj0hn]

i just want to know if i can make something on my gateway or pda without modifying my back end.. thanks for the replies..
________
TOYOTA VANGUARD SPECIFICATIONS