screach
asked on
Interfacing microcontroller to a database.
I wasn't sure what section to put this question in cos it deals with software, hardware and databases but here goes.
I am doing a final year project in college. The project is a security system in which a database will control the access rights of individuals. The project involves reading an 64-bit number from what is called an ibutton ( www.ibutton.com). Each person will have there own ibutton with a unique number. The number will be read by an 8051 microprocessor and stored. I then have to send the number to a computer to verify that the number is in the database to check if the person has access rights. I am just a bit confused about this part. Should i use an ethernet connection or an RS232 to communicate with the microcontroller. If so how would i set it up that access is automatically executed when the computer recieves a number from the microcontroller, that the number is passed in to access and that a signal is sent back to the microprocessor to open the door. It's just all a bit confusing for me and i don't even know where to start so any help would be appreciated.
I am doing a final year project in college. The project is a security system in which a database will control the access rights of individuals. The project involves reading an 64-bit number from what is called an ibutton ( www.ibutton.com). Each person will have there own ibutton with a unique number. The number will be read by an 8051 microprocessor and stored. I then have to send the number to a computer to verify that the number is in the database to check if the person has access rights. I am just a bit confused about this part. Should i use an ethernet connection or an RS232 to communicate with the microcontroller. If so how would i set it up that access is automatically executed when the computer recieves a number from the microcontroller, that the number is passed in to access and that a signal is sent back to the microprocessor to open the door. It's just all a bit confusing for me and i don't even know where to start so any help would be appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes my project supervisor had mentioned something like that. I think that Rabbit semiconductors is a bit out of my budget but the EDTP electronics looks good. What to you think of this one:
http://www.siteplayer.com/
Sorry for the stupid questions but would this just involve writing the database and a bit of SQL for the queries or would i still need a C program to communicate with the microcontroller and pass the number to access. What do you mean by send a string from the microcontroller to the computer is it?
http://www.siteplayer.com/
Sorry for the stupid questions but would this just involve writing the database and a bit of SQL for the queries or would i still need a C program to communicate with the microcontroller and pass the number to access. What do you mean by send a string from the microcontroller to the computer is it?
It appears to be the inverse of what you want.
To access the web page you don't need a C program, just assembler, but C will be more clear.
To access the web page you don't need a C program, just assembler, but C will be more clear.
ASKER
Do you know of any good sites that i could get information about these microcontrollers that would help me with the project.
Thanks,
Jonathan
Thanks,
Jonathan
Web enabled microcontrollers and related books and articles:
http://www.edtp.com/
http://www.rabbitsemiconductor.com
http://www.edtp.com/
http://www.rabbitsemiconductor.com
Dissadvantage is that if using a Network access is in complexity of the micorcontroller, but there are many advantages.
like:
- you can use multiple devices ... for controlling (255 and even more)
- very simple network application
- you'er not boud to the cable length much as with the RS-232
on the other hand the RS-232 acces is more simple - direct communication and you can controll it with a aapplication simmilar to a mouse driver ...
Hope this helps a bit ...