C/Front with Windows CE

Hi,

I've worked quite a bit with WinCE, Barcode Scanner and Navision sitting in SQL Server.

There is at least 3 solutions I've came up with, and none of them using CFRONT. Nevertheless I will just share it here.

1. Realtime scanning - Terminal Service Client
WinCE normally comes with Terminal Server Client, so what I did was to create a Navision screen just for the purpose of scanning, i.e Specific user ID, specific form, and use wireless connectivity to connect to any Terminal Server.
For the HW I use Pocket Loox 610 and ActiveScan the barcode scanner.

2. Realtime scanning - OLEDB
I ever developed a solution using OLEDB from WinCE. Microsoft has embedded visual tools free for download. You can use this and develop custom application into your WinCE devices and connect to SQL using OLEDB.

3. Batch Scanning - SQL Server Replication and SQL Server CE
As the name suggest this time round SQL Server Merge Replication is used. The tricky part here is that to get Navision user to fill a temp table, synchronize this table to WinCE device. At the WinCE device again use embedded visual tools to capture your serial no or whatever, save it to SQL CE, replicate back to Navision temp table and use Navision job scheduler to update any table you need from the temp table information.

I'm sorry if I lost you, anyway these are just ideas - on how you want to implement it, it's up to you.
I personnaly like the third one best, although not as real time as the first two, but it gives better stability (as last time I was having some problem with the intermitten connectivity of the WinCE)

Rgds,

Jon.

We have customer which is using Symbol too, and solution is the terminal server with Navision with special "small" windows for the Win CE - do not set resolution of the terminal server to fix the screen, set the windows to this settings:

Width = 5720 (+/- some value)
Height = 6050 (+/- some value)
Maximizable = No
Sizeable = No
AutoPosition = CenterScreen
SaveTableView = No
SavePosAndSize = No


Use minimal font size 7, you can disable the status bar and the menu bar on the terminal server and if you run Navision after logging to the TS automatically, it is easy and simple solution for you... Remember, that every message box etc. must have short lines to fit to the screen (users only center the screen to the middle and they see whole window (create special main menu for the users to see only needed functions on small window)...