Need help with writing data to the table in SQL server express 2012 database using labview

[Dennis_Knutson]

None of that makes any sense. The wait is not required, nor the while loop. If it works at all, it would just keep writing the same data over and over again. What is the actual data type in the cluster? I suspect you need a for loop to write each row.

[manny09]

If you are planning to write a lot of data and really fast into SQL table, You should make the VI in 2 steps. 

Step 1: Write the data to a text file

Step 2: Read from text file and write to the SQL table. 

The reason being that you cannot write really fast and lot of points from labview to SQL. You will loose half of the points in the process. 

When you write to the text file, its way faster and you have all the data secured. Then you can run the other part and it might take like 5 mins approximetly (depending on the number of points you are reading) to send the data to SQL. 

[manny09]

I have attached an example for reading from text file to SQL. Maybe that helps

[Dennis_Knutson]

I've been using the database toolkit since before it was owned by NI and have never lost data or had to resort to writing to a file.

[dzehner2]

---

@Dennis_Knutson wrote:
None of that makes any sense. The wait is not required, nor the while loop. If it works at all, it would just keep writing the same data over and over again. What is the actual data type in the cluster? I suspect you need a for loop to write each row.

---

The actual data type is DBL, it's just acceleration in g. I had the wait and the while loop in there from the example on continuous logging, but I had suscpicions it wasn't really necessary. 

[dzehner2]

---

@manny09 wrote:

I have attached an example for reading from text file to SQL. Maybe that helps

---

Let me just make sure I understand your VI... You write to a text file, and then call that file name into the loop that connects to your SQL server and insert it into a table? That would work... I'll give it a shot!

[mikeporter]

First off, you only have to create the table once -- ever. While you can do that in LV, you will hardly ever want to.

Second, the DCT will make life infinitely more difficult for you. The process for inserting data into a database is really very easy and the DCT does an excellent job of hiding that simplicity beneath a complex, proprietary interface.

Check out this thread for most of what you need to know to use databases easily -- including some free drivers.

Mike...