A Database who is not Citadel

[aSquared]

Hi,

I am using LabVIEW 8.2.1 RT DSC.

I would like to store some measurements results (analog continuous measurements),

in a "regular" database (not Citadel).

Since I am a bit familiar with SQL, I have Purchased SQL connectivity toolkit.

and I have seen some of the examples and managed to create a .udl file, to create a table and to log some Shared Variable Timestamp and Process Value (PV), (only when the PV changed).

and I have managed to create a VI that reads the data from the Database and plot it to a online graph.

I have noticed that my database is Microsoft access via Microsoft SQL server 2005 (that came with the DSC).

I want a bigger database than 4 GB.

what do you recommend ?

 Can I use Mysql or Oracle with the SQL connectivity toolkit ?

Can I import data from Citadel into a Table in a "regular" database ?

(I have read 'Accessing Citadel 5 from other software' but I did not understand how it is been done)

Sincerely Yours,

Amitai Abramson.

[A_Patel]

Hi Amitai,

Would you beable to just use a SQL Query to move the data into a SQL database?

http://digital.ni.com/public.nsf/allkb/A444194CCC921FE586256F80006460A8?OpenDocument

cheers,

Flash

[aSquared]

Hi,

Thank you for your reply,

Your suggestion is interesting for the short term, but for the long term I would like

to store the data in a database like MySQL.

A few questions -

1. Does your suggestion is also applicable for Citadel 5 (not only 4)?

2. Does the MS SQL Server 2005 that "came" with DSC can create a crash with MySQL installed on the same computer

3. Can you give me a reference to how link LabVIEW via SQL Connectivity Toolkit to a MySQL Database

   (so I will be able to query the MySQL Database through SQL Connectivity Toolkit) ?

Sincerely Yours,

Amitai Abramson

[F._Schubert]

This is not an anwser to the your questions, but also take a look of this great community post:

The LabVIEW SQL cheat sheet

Felix

[A_Patel]

Hi Amitai,

Yes it will work for Citadel 5.

Are you asking if it will crash with MySQL? Or are you experiencing the problem?

Connecting to the MySQL Database through the toolkit shouldn't be any different than the SQL-Server method. You create a .dsn file that points to the mysql database then reference the .dsn file. Do you have a database definition for windows (most likely odbc).

 http://zone.ni.com/devzone/cda/tut/p/id/3563

Flash

[aSquared]

Hi,

Thank You for your reply.

1. I am asking if it will crash. some type of MS SQL Server 2005 is installed (at the Server Computer), this installation was performed automatically when I have installed DSC Module. It is just sometimes MS products "don't like" other products, so I am asking if it will crash with MySQL.

2. I have created (as a test for SQL Connectivity Toolkit) a .udl file and I have noticed that tables I create and data I insert into those tables goes to some MS Access file .mdb (location - C:\Program Files\National Instruments\LabVIEW 8.2\examples\database).

Will it be that simple with MySQL too?

Will the linkage will be also through a .udl file?

Sincerely Yours,

Amitai Abramson.

[A_Patel]

Hi Amitai,

1. No it will not crash with MySQL.

2. And theas faras the ease of MySQL, I am not completly sure of the ease of use, but from the research I have done, it should be just as simple.