Handheld scanner & code/software for MS SQL

Posted on 2009-02-17
Last Modified: 2013-12-27

We need for our stock an handheld scanner which is capable communicating with MS SQL server somehow.

- 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...
Question by:joop123456
    LVL 5

    Expert Comment

    Well, you would need to write your custom application for that task, and that might cost a good peace of money :-)

    It is possible to develop a program reading barcode and comunicating with MS SQL server via WiFi for example.

    Author Comment

    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...
    LVL 5

    Accepted Solution


    Author Comment

    Fine, custom programming. I understand, but that's the last choice.

    No opensource software somewhere or similar situations?

    Author Comment

    moderator please delete this question..

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Once again I push the limits of my phone.  An introduction to the Android Google Now Launcher.
    If your app took Google’s lash recently, here are the 5 most likely reasons.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now