joop123456
asked on
Handheld scanner & code/software for MS SQL
Hello,
We need for our stock an handheld scanner which is capable communicating with MS SQL server somehow.
Stituation:
- a parcel is picked together, and being loaded on a truck
- when scanning a barcode, search for particular db-record, and change status to "shipped"
IF scanned.pack_ID exists in tblpackage.pack_ID
THEN change tblpackage.status to "shipped"
ELSE do nothing "error, ID does not exist"
Have no industrial longrange wireless handheld scanner yet, thinking about buying:
- Datalogic Powerscan M8300, or Motorola/Symbol LS3578
Was first thinking about a handheld pda scanner with windows CE, like the Intermec CK31. But I think a wireless handheld scanner only is more bullet-proof?!? (anyway a lot cheaper)
What's the approach? All hints/directions are welcome...
We need for our stock an handheld scanner which is capable communicating with MS SQL server somehow.
Stituation:
- a parcel is picked together, and being loaded on a truck
- when scanning a barcode, search for particular db-record, and change status to "shipped"
IF scanned.pack_ID exists in tblpackage.pack_ID
THEN change tblpackage.status to "shipped"
ELSE do nothing "error, ID does not exist"
Have no industrial longrange wireless handheld scanner yet, thinking about buying:
- Datalogic Powerscan M8300, or Motorola/Symbol LS3578
Was first thinking about a handheld pda scanner with windows CE, like the Intermec CK31. But I think a wireless handheld scanner only is more bullet-proof?!? (anyway a lot cheaper)
What's the approach? All hints/directions are welcome...
ASKER
What I'm actually looking for is everything but custom programming... Opensource or other software brands/packages? I can not imagine that this not existing... data is probably for 95% kept in databases.....?!? So I need some names or a start-path...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Fine, custom programming. I understand, but that's the last choice.
No opensource software somewhere or similar situations?
No opensource software somewhere or similar situations?
ASKER
moderator please delete this question..
It is possible to develop a program reading barcode and comunicating with MS SQL server via WiFi for example.