database management and RFID interface

[raja_karthick]

hi frnds, i need to know two things

1. can we interface an RFID tag with labview through PC and read the data stored in the RFID tag??'

2.if so, then how can i match the read data with a predefined database present in labview?? and how to create databases in labview?

please provide me suggestons with this

[Dennis_Knutson]

You would need to find an RFID reader that has a driver that LabVIEW can use. A virtual com port is common.

You would not typically create the database in LabVIEW. That's a one-time operation that is best with the database program. Finding an item in the database is simply performing a SQL SELECT statement. Do you have the Database Connectivity Toolkit?

[mikeporter]

In terms of the database, here's a place to get some good information:

http://www.notatamelion.com/2015/01/05/managing-data-the-easy-way/

Also read the following post as well.

Mike...

[raja_karthick]

no, i have not yet installed the database connectivity toolkit

[Dennis_Knutson]

When you do, there will be examples you can look at. The operation is pretty simple.

Have you decided on the database and have you installed that? You have numerous options ranging from Jet (MS Access) to much more robust and server based such as MySQL or SQL Server.

[raja_karthick]

is it possible to use excel database for retreving and storing data?? as shown in the below link

https://www.youtube.com/watch?v=L-Qd3X5d9G8

[raja_karthick]

@dennis, i am planning to use excel database?? is it possible as shown in the above link?

[mikeporter]

You can use ADO to connect to an Excel spreadsheet, but there are restrictions on how the spreadsheet is structured. For detail Google "accessing Excel with ADO".

In your excel spreadsheet create one worksheet to hold your "database" and then use spreadsheet references to access the data elsewhere in the document. In this situation the name of the worksheet becomes the "table" names used in ADO.

Is there a reason you aren't using an actual database like Jet?

Mike...

[Dennis_Knutson]

If you insist on Excel instead of a real database, you would be better off with the Report Generation Toolkit and ActiveX for Excel.

[raja_karthick]

@mike, i belong to electronics stream and i am not very much experienced with tools like SQL, that is the reason