December 17, 2004 at 10:01 am
Hi everyone,
I've talk to my boss this morning and he wants to implement a files tracking software to know where the department files are (physical files!). Files are moving to 4 differents points during the day and he wants to track that movement and the date it's done.
I want to install a bar code scanner on those desk (4 in total). We already have bar code snanner in the company, but they are all plugged into a old computer that receive the data and sends it to sql server (from an ms access application).
This time, I don't want to plug the scanners into a computer, so I would like to have wireless bar code scanners that sends the data directly to Sql Server without a computer between the two. The problem is, I'm not sure how to make this work. I guess I would have to send the data througth a stored proc that inserts the data in the table... but how to send from the scanner to stored proc?
Anybody have done this before?
Thanks,
Eric
December 17, 2004 at 12:13 pm
No that sounds like dealing with specialized hardware and will need an application of some kind to intercept the data and forward to sql like was going on with the access db. Barring the wireless part how did it work to get it in the access database?
December 17, 2004 at 1:02 pm
My current system is easy to implement. I've got a scanner that scans the bar code into text fields in ms access (it is plugged in the keyboard). Access sends it to sql server in a SP which inserts into the database.
I guess it would'nt be so hard to get a scanner that send data to a server... many companies use bar code scanner in their warehouse. I just can't figure out how to do that.. and don't want to buy four 500$ scanner just to find out I figured it out the wrong way!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply