Interfacing microcontroller to a database.

Posted on 2004-11-02
Last Modified: 2008-03-06
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 ( 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.
Question by:screach
    LVL 3

    Expert Comment

    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.
    - 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 ...
    LVL 55

    Accepted Solution

    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:

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

    You can use any board of EDTP electronics or Rabbit semiconductors

    Author Comment

    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:

    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?

    LVL 55

    Expert Comment

    by:Jaime Olivares
    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.

    Author Comment

    Do you know of any good sites that i could get information about these microcontrollers that would help me with the project.

    LVL 55

    Expert Comment

    by:Jaime Olivares
    Web enabled microcontrollers and related books and articles:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Suggested Solutions

    Since 2008, the stock markets have been in a haphazard state of fluctuation. At times it has been a steep decline (2008) and at others, a steady incline full of promise (2010). Just weeks ago, in August 2011, together we saw the stock markets plunge…
    Phishing is at the top of most security top 10 efforts you should be pursuing in 2016 and beyond. If you don't have phishing incorporated into your Security Awareness Program yet, now is the time. Phishers, and the scams they use, are only going to …
    The Bounty Board allows you to request an article or video on any technical topic, or fulfill a bounty request to earn points. Watch this video to learn how to use the Bounty Board to get the content you want, earn points, and browse submitted bount…
    Notifications on Experts Exchange help you keep track of your activity and updates in one place. Watch this video to learn how to use them on the site to quickly access the content that matters to you.

    857 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now