Read data from external source via ethernet

Projects Networking, Protocols, and Devices
1

Hi folks,

I am trying to program a door access control for my and my father's garage. When a RFID tag is swiped, Arduino either grants or denies access. I could store the code of the tag in an arduino script but this would then be a hardcoded solution. I'd prefer to read the code being allowed to open the garage from network. I would be file with csv file from a share, ftp or web Server or a simple Microsoft SQL Server query.

Any ideas how to achieve this without programming Ages creating houndreds of lines?

2

Have you ANY networking experience? It is not difficult to have the Arduino make a GET request, and parse the response. A couple dozen lines of code, maybe.

The GET request goes to a server, where a script (that you write) queries the database and returns some data. Nothing particularly challenging about that. Another couple dozen lines of code.

Total time to working solution, if you know what you are doing, can be a couple of hours.