• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 776
  • Last Modified:

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.
0
screach
Asked:
screach
  • 3
  • 2
1 Solution
 
PhysicistmCommented:
Well if you're using a Network controller in this case you have to build up a whole small microcomputer / microcontroller which will have it's own IP address, and on the compute rpart build a small application which will monitor the device over the network and communicate with the database.
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 ...
0
 
Jaime OlivaresSoftware ArchitectCommented:
I recommend you to use a network enabled microcontroller/board, and make queries to a web page, this way you will handle all database management at server side. You just send a string like:

http://10.1.2.3/checkdoor.php?id=574847383412

You will get a web page as result where you can analyze response.

You can use any board of EDTP electronics or Rabbit semiconductors
0
 
screachAuthor Commented:
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?

0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Jaime OlivaresSoftware ArchitectCommented:
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.
0
 
screachAuthor Commented:
Do you know of any good sites that i could get information about these microcontrollers that would help me with the project.

Thanks,
Jonathan
0
 
Jaime OlivaresSoftware ArchitectCommented:
Web enabled microcontrollers and related books and articles:
http://www.edtp.com/   
http://www.rabbitsemiconductor.com
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now