Equipment/asset management with LabVIEW

[Ryan_G_EE]

I would like to write a basic equipment/asset managment program with LabVIEW, since I just haven't liked the commercial ones that I have tried for various reasons.

My question is how can I manage the information using LabVIEW...? Is there any way to create a small database file (perhaps *.csv) with LabVIEW and be able to easily update the fields in that file as the asset status changes?

[Dennis_Knutson]

I would use the free SQL Server or MySQL database.

[mikeporter]

You can, but you should use a real database. NI installs the free version of SQL Server when you load the data supervisory control toolkit (and leaves it there if you uninstall the toolkit). MySQL and SQLite are available online and Jet is built into Windows.

Don't however use the database connectivity toolkit -- not worth the effort.

Mike...

[mikeporter]

Oh yes, there is also a free version of Oracle available.

Mike...

[AnalogKid2DigitalMan]

Mike

Curious as to why the Database Connectivity Toolkit is not worth the effort? I may have a need to use it in the near term. Is the OP's application overkill for the Toolkit?

Thanks

-AK2DM

[mikeporter]

Check here for a complete discussion.

Http://forums.ni.com/t5/LabVIEW/Extracting-one-column-from-Database/m-p/547276#M257531

Mike...

[AnalogKid2DigitalMan]

Thanks Mike, I shall disgest that discussion when the time comes, now bookmarked.

-AK2DM