Mag-Stripe Devices for a LAN?
bugaloo2 writes "Is there such a thing? I'm looking for a magnetic stripe (magstripe) card reader of some kind that can connect directly to our network and read/write data to a SQL table. There are dozens of different serial, usb, and ps2 style card readers to connect to a PC, but none that I have seen can connect directly to a LAN. If such a ghost does not exist on the market today, how would you (cheaply) implement an access card security system for several buildings using existing network infrastructure and hardware if possible that reads/writes to a SQL table for security access?" We did a related question not too long ago.
Start with a serial mag-stripe reader (many can be gotten for cheap from surplus electronics outlets like All Electronics).
;)
Add a Basic Stamp 2 from Parallax (or maybe your own PIC and extra EEPROM) and a MAX232 to communicate to the reader.
Connect that to one of these boards.
Write your own custom code to do real basic IP stuff for the networking (have fun!)...
Should be able to do all this cheaply - less than $300. Hard part is the coding, getting a small IP stack written to fit, and comm protocol code as well. It is more than possible though...
Finally, when you have it all done, got the VC's lined up stuffin' your pockets with cash, and you bring it to market - think of me, and send me a check of appreciation...
Worldcom - Generation Duh!
Reason is the Path to God - Anon
I'm a technician on a campus that uses the CampusWide system (Optim9000). AT&T actually sold off the CampusWide division to Blackboard.com late last year. This is the updated URL. The system runs on an HP-9000 server (HP-UX 10.x, soon 11.x), and uses its own proprietary network format and database (I think it's called Raima, but don't quote me.) It can run across a standard LAN, but for reliability, it's usually set up to run on its own separate network. CW is supposed to be releasing a piece of hardware that will allow readers to use IP addressing, but it hasn't materialized yet (they keep saying 'soon'). The system can handle point-of-sale, access control, digital photo-ID production/management(uses an Informix database and DataCard software/hardware to store pictures/print IDs) and scales upwards effortlessly. Our campus has well over 200 readers, 15,000+ cardholders, and 99%+ up-time. I know that USC, UCLA, Duke, Harvard, and around 400 other schools use this system. (Even Honda Motor Co. uses it at one of its plants.) It's not cheap, though. Hope this helps.