Citadel Database - Suggestions

[Sowmya.R]

Hi,

         I need to log data for a long duration. From the survey i came to know about the citadel data base. Can i get it without having DSC module If yes, please give the site address and let me know how to use it. If no, please let me know which is the best database that can be used since i have to deploy the database with the application.

       I have used MS Access previously but i cannot use it now since it has a constraint of having maximum 2 GB data and i need to log more data than that. So could any one suggest me what to do.

Regards,

Sowmya

[Nitin_T]

Hi Sowmya,

Citadel is not available as an independent software which can be downloaded and installed. It comes along with the DSC Module, Lookout, VI Logger and DIAdem (optional). Also, Citadel does not have a specific size limitation, unless it's a limitation brought about by the file system in the PC - NTFS or FAT32. I would suggest going through the Citadel White Paper and browsing to the Database Size Considerations and Installing Citadel sections within the paper. Have a great day.

[Dennis_Knutson]

Why not give MySQL a try

Message Edited by Dennis Knutson on 11-20-2007 12:30 PM

[Sowmya.R]

Hi,

        Thanks for the suggestion to use MySQL but can you please answer few of my questions

• Can i deploy MySQL like MSAccess, i.e., when i install an application using Installer on another PC will the database also get installed or should it be separately installed in that system.
• How do i use MySQL - is it through connection string? How to use them to connect to database.

 If you have any examples can you please pass it on.

Regards,

Sowmya

[Dennis_Knutson]

I've never tried to deploy any type of database with the LabVIEW installer. Since the latest version of the LabVIEW app builder has the ability to include other installers, I suppose this is possible.

You would use MySQL in the same way you are using Access, assuming you are using the Database Toolkit or something similar based on ADO. I don't use the database toolkit so I'm not sure what (if any) changes you might have to make. The actual database that I'm using is SQL Server and we deploy a run-time version of that. I've experimented with MySQL but that is about the extent of my experience. I mentioned MySQL because I assumed you were looking for something free.

[nhollenback]

For free databases, I recommend SQL Server Express. I wrote a database application with a web front end that ran an auction and processed over 300 orders totaling almost $100k. The free tools from Microsoft worked flawlessly (with the exception of one glitch on the web side). Just go to Microsoft, search and download. I did not find the tools for MySQL to be as friendly to use.