I am using h5labview on a windows PC connected to a cRIO. This seems to work fine. I rather would like the file save be running on the cRIO though. Does anyone know if there is a howto on this subject? The most recent link I can find is this one:

https://sourceforge.net/p/h5labview/discussion/general/thread/479d0cdf61/?limit=25#c81d

the link is a few years old and if I would be able to compile and get a *.o file I would not know howto use it on the cRIO. I have some Linux experience I can setup a VM with Linux. I use Labview 2024.

any help is appreciated thank you!

I am working on a R&D project which need to acquire and record images at 180FPS. I intend to convert image data to byte array then to string then save to TDMS file. I just figured out TDMS does not save string with NULL value. I don't think it's a good idea to save byte array since it will be difficult to index images with a large size array.

Could you please give me some advice on what I should do?

Sincerely,

Thang Nguyen

Firstly, thanks James for creating the excellent SQLite and JSONText libraries. 

I've been working on a proof of concept for storing time series data into an SQLite database. As it stands I've decided upon a simple table, with two columns, Unix time (as my PK) and Data as a JSON string with an unknown number of channels e.g;

The schema is;

CREATE TABLE [Data_1s](
  [Time] PRIMARY KEY, 
  [Data]);

CREATE INDEX [idx_time] ON [Data_1s]([Time]);

Currently my example dataset is 50 channels at 1Hz, for 1 day. I'm aiming to test this for a years worth of data. 

Point Values

I'm getting very good performance when extracting an individual time row (e.g. via a slider between the start and end time of the data set);

The current query I'm using is based on an older form of storing the time (as a decimal) so I searched for a 1s period; 

SELECT Time, Data 
FROM Data_1s 
WHERE Time
BETWEEN 1717606845 AND 1717606846

I then collect the results, extract the individual channels from the JSON data and pop it into a map;

This of course can be optimised, but given it is sub 5ms, it is plenty quick enough for interacting with the data via a HMI.

Graph

Anyway, when it comes to extracting XY data to display on a graph, I use the following to for example only extract Channel 0;

SELECT Time, json_extract(data,'$."Channel 0"') AS Channel_0
FROM Data_1s 
WHERE Time BETWEEN 1717656137 AND 1718860565

In the above example I read 1892 elements from the database, and it takes ~ 19ms. Fast enough for the user to drag a slider around and change the time window. 

However, if I go for my full example data window, e.g;

SELECT Time, json_extract(data,'$."Channel 0"') AS Channel_0
FROM Data_1s 
WHERE Time BETWEEN 1717571628 AND 1718860565

It takes 852ms to read 86400 elements. If I go for all 50 channels it increases to 8473ms. 

Now with a graph with of a 2000 odd pixels, there isn't much point in loading all that data into LabVIEW, so I implemented an average down sampling query, based on an interval size;

WITH TimeGroups AS (
SELECT
(Time/60) *60 AS TimeGroup,
json_extract(data,'$."Channel 0"') AS Channel_0
FROM Data_1s
WHERE Time BETWEEN 1717571628 AND 1718860565
)
SELECT 
TimeGroup,
AVG(Channel_0) AS Avg_Channel_0
FROM TimeGroups
GROUP BY TimeGroup;

This takes 1535ms to run, returns 1441 elements. This is worse than reading the 86400 elements and letting LabVIEW manage the down sampling. 

#

The questions I broadly have are;

• Am I totally off base with the schema and using JSON to store the (unknown) amount of channels?
• Should I be looking at a different way of down sampling?
• How are large datasets like stock prices stored and distributed to display on the internet? Some must have very long time series data spanning over decades! 
• How do you store and quickly extract datasets for display?

Although I feel my questions are pretty broad rather than code specific, I can package it up and share after I strip a bunch of bloat out as it still very much a POC if that would help.

Thanks

Peter

anyway , i like the idea of the meta data aspect vs a text file...

what i am looking to do is write 350-400 data points per second , for this particular test it is basically 10 rows x 35 or so columns...

i have mocked up some simulated data etc... when i try to write the 10 rows , it is very slow ... if i write all 216000 rows at once after the data , it is very fast , however , this test will run 12-18 hours , so i do not want to wait until the end to write the data ...

if someone could point me in the right direction that would be great.

Regards

Dan

I'm planning to expose metrics for Prometheus to collect (scrap) them.

I saw the PromVIEW VIP on GitHub and vipm.io which works in the default Prometheus way : your app runs an HTTP server and Prometheus is configured to connect to it to collect your metrics.

My issue is that I run my app on Linux (Ubuntu) and the NI Web Server is not supported on Linux.

I've seen that Prometheus can also be configured to collect metrics from a file as long as we follow the correct format, so I will most probably follow this path.

As anyone done this or anything similar?

drjdpowell_lib_sqlite_labview-1.11.0.86.vip

in a larger application, sometime a small ini files get corrupted (a lot of NULL char and nothing else inside), and it looks like it happens when the computer restart and the application was running. I found this NI page: https://knowledge.ni.com/KnowledgeArticleDetails?id=kA03q000001DwgyCAC&l=it-IT where the use of the "Flush file.vi" is suggested.

But a vary minimal and simple test like this one:

returns Error 1, always. And I really really cannot see what I'm supposed to do differently. It's problably something VERY stupid. Anyone here can help me?

Thank you,

Marco.

I am connecting to an SQL server running 10.5. Using LabVIEW Database Connectivity toolkit and/or TestStand's Database Viewer I can successfully open a connection and run a simple query which returns the proper records. A more advanced query and no records are returned and the properties show that the state is closed. Copy and pasting this query into Microsoft SQL Server Management Studio successfully fetches the correct records. Also running this same query in python using pyodbc returns the correct record.

The VI is straight forward. I attached the snippet.

My first thought is that the string contains some bytes in codes that causes the query to be interpreted wrong by NI's tools. Does anybody have experience as to why a query works in other environments but not in NI's tools? Again, a simple query did work, but a more complex one did not.

Thanks!

I would really prefer to use the library as written rather than modifying it.  Does anyone have suggestions on ways to pass the handle through a variant from packed library to packed library? I included a screen shot of some of the attempts to get it to work as the connection handle or as a reference. Here is the difference between the variant when unpacked vs from a packed library.

'PQ Conn' -> PQ Connection.lvclass
'PQ Ref' -> F0C000A7
'Numeric' -> 466326216

'PQ Conn' -> Product Initialize.lvlibp:PQ Connection.lvclass
'PQ Ref' -> 5C7000FC
'Numeric' -> 466328936
 

As best I can tell wrapper from the packed library makes them incompatible and I have not found any way to get them to translate.

To be fair I also went through the effort of converting everything to ODBC and using those tools with similar problems on passing the handles.

The type infrencing code was based on JDP Science's SQLite Library. Thanks!

create and insert from cluster.vi

Iam a beginner to labview,Currently i am facing a problem with the ActiveX data objects library ,where when i try to open a connection. the thing i do here is creating a automation refnum ,passing it through a open automation vi and using a invoke method to open a connection ,while doing this when the automation ref num is being passed through the open Automation vi it throws the below quoted error

ERROR text:

"Error 3005 occurred at Automation Open: Object specified is not creatable in Open SQLServer Connection.vi

This error code is undefined. Undefined errors might occur for a number of reasons. For example, no one has provided a description for the code, or you might have wired a number that is not an error code to the error code input. 

Additionally, undefined error codes might occur because the error relates to a third-party object, such as the operating system or ActiveX. For these third-party errors, you might be able to obtain a description of the error by searching the Web for the error code (3005) or for its hexadecimal representation (0x00000BBD)."

not sure why lab view is throwing the error .Interesting thing here is ,i use the same method to open connection in a different project. There the operation runs successfully without any error.

DB used here is MSSQL

lab view version is 2018

It would be of much help if someone could provide me with the solution .uploading a screen snip of my VI.

I'm using a data acquisition device to get measured temperature, force, pressure and i would like to save those data (with header) on a spreadsheet file when i press a button (the "write to file" button in the Vi attached) and stop recording data when unpressed. I can now do this but if i stop and restart the recording the new data are just appended to the previous file without header, so i cannot distinguish when a new recording started.

Actually what i wanted to achive with this Vi was to automatically create a file with a specified name (with header wich is only present one time in it) that is changing to each press of the button and without asking for a new path for every new file.

Is there a way to simply do this?

thank you.

MVB.vi così.txt

And why I am getting this error, that basically should never happen? This: https://sqlite.org/rescode.html#mismatch says it should only ever happen when trying to set a rowid to something other than an integer. I'm not doing that.

See https://forums.ni.com/t5/JDP-Science-Tools/BETA-version-of-JSONtext-1-6/td-p/4146235

For those unfamiliar, HDF5 is a binary data format widely used in the sciences. It's similar to TDMS in some ways, but more flexible and less proprietary. Keeping up with the ever changing ABI of the underlying HDF5 library has been a losing battle, so I quit a long time ago and accepted that Live HDF5 would most likely only work with the version of HDF5 it release with. (Fortunately, while the ABI changes a lot, the file format itself has always been backwards and mostly-forwards compatible.) Some features in version 1.12 of HDF5 were very attractive to me and prompted the update. The update also provided a chance to weed out some long-standing bugs.

The toolkit may also be of interest to those who like playing around with Xnodes.

https://www.upvi.net/main/index.php/products/lvhdf5

I have a problem with SQLite file locks ...

I created a datalogger in Labview that saves the data acquired from a customer's custom equipment in an SQLite database. I used Powell's library (an egregious library!)

Although the capture is continuous, the data is not stored in a single SQLite file but on different files lasting about 1 hour each.

At each time change the software closes the database currently in use (with SQLite Close) and create a new one. The database reference remains open all the time until it is closed at the next hour change.

These SQLite files are downloaded from another application running on a second PC using FTP. (the machine running the data logger has a FileZilla server) What happens is that it is not possible to download any SQLite file created by the data logger until the application is stopped!

By stopping the application and restarting it, you can download all the files created before the restart but not those created afterwards! It is as if a lock is maintained on all files created until the program is closed!

I would expect the lock to be present on the file currently in use, but not on those already closed.

Has anyone experienced this behavior before?

Thanks for any help you can give me.

Osvaldo

C:\LabVIEW Working Folder\Tester Software\data\Error Log.txt 

Now for some unknown reason randomly but usually on the close i get a file dialog box asking which file to write... 

Any idea what I'm missing... what stupid mistake did I make? It just doesn't make sense...

I have received some code from a customer which is created with LabVIEW 8.2.1. It uses an old add-on tool for accessing an SQL database, but I cannot find that tool anywhere. I can see that the VI's I have are trying to load sub VI's from "<vi.lib>:\addons\SQL\Access" and then a number of different llb files.

Can anyone her point me in the direction of which tool kit this comes from? Is it a very old version of the Database Connectivity tool kit or is it something else?

Thanks.

1. Select the temp table -> output array
2. Compress  the output array of step 1
3. Insert the compress data from step 2 to actual table
4. Drop the temp table

I am looking for an option to mix these steps together to speed up the speed for example select and delete the row in temp table at the same time then at the end I can drop the table faster. Currently, it takes significant time to drop the table. Our raw data can be up to 3GB. But I don't know how to combine the query. I also read that SQlite does not support this. So I also looking for an advice on how to make this process more efficient. I thought about using the queue too but I need input before I change it.

Thank you in advance.

I would like to create an applications for students in a laboratory that will write data acquired from sensors directly to a MySQL server.

I am using Data Link tool to create a data link to the database. I need to hide Server credentials from a user (such as a student) that will have access to code. Any suggestions ?

thank you

let me present our new ANV Database Toolkit, which has been recently released at vipm.io.

Short introduction to the toolkit is posted by this link, and it also describes steps which should be done in order to use this toolkit.

ANV Database Toolkit helps developers design LabVIEW API for querying various databases (MS SQL, MySQL, SQLite, Access). It allows to create VIs which can be used as API with the help of graphical user interface. When using these VIs, toolkit handles connection with the database, thus relieving developers of this burden in their applications.

It has the following features:

• Simplifies handling of databases in LabVIEW projects
• Allows to graphically create API VIs for Databases
• Supports Read, Write, Update and Delete queries
• Supports various database types (MS SQL, MySQL, SQLite, Access)

Overall idea is that developer could create set of high-level API VIs for queries using graphical user interface, without actual writing of SQL queries. Those API VIs are used in the application, and handle database communication in the background. Moreover, SQL query could be applied to any of the supported database types, it is a matter of database type selection. Change of target database does not require changes in API VI which executes the query.

After installation of the toolkit, sample project is available, which shows possibilities of the toolkit in terms of execution different types of queries.

Note, that in order to install the toolkit, VI Package Manager must be launched with Administrator privileges.

This toolkit is paid, and price is disclosed based on price quotation. But anyway, there are 30 days of trial period during which you could tryout the toolkit, and decide whether it is helpful (and hope that it will be) for your needs.

In case of any feedback, ideas or issues please do not hesitate to contact me directly here, or at vipm.io, or at e-mail info@anv-tech.com.

I made a library for reading/writing MATLAB Mat-files in LabVIEW, and posted it on Sourceforge. It's written in pure G, with no external DLLs. Anyone is welcome to use the code if they want. It can be downloaded at http://matio-labview.sourceforge.net/. If you do try it out, I would appreciate any feedback you could provide.

Here is some sample code. I'm writing a cluster of various items to the file test.mat. This will create a structure in MATLAB with field names derived from the labels of the items in the cluster.

After running "load test.mat" in MATLAB, here is the result (shown in the variable editor):

Thanks,

Jim

In the web service VI, I am now opening the database and set a long enough busy timeout and then pass the query from web service calls to SQLite EXEC SQL. But my test showed some queries are not executed. 

So SQLite is not automatically queuing the writing queries? What is the proper way to ensure all queries queue up and get executed?

I thought it's a basic thing I want to solve but didn't find appropriate answers.

Thanks for any hints in advance!

I am writing array of timestamp in TDMS file. "TDMS Write.vi" generates an error after calling this VI as follows.

Group Name = "DUT T1"

Channel Names = "DUT T1_Time"

Please let me know if anyone has any suggestions.

BR

Aniket

I would like to know if I can write stream data into two different tables with SQLite at the same time or not? Currently my system has one camera. I store the capture images and particle measurement in one table. I have just add one more camera to the system and would like to do the same thing and write to a second table in a parallel process.  I wonder if this is possible or not.

I use SQLite library.

Thanks in advance.

I have been having an issue trying to resolve an error all afternoon, and hope that you might be able to help.

I am trying to execute the follow SQL "

SELECT m.name as tableName,
       p.name as columnName
FROM sqlite_master m
left outer join pragma_table_info((m.name)) p
     on m.name <> p.name
     where columnName = 'UploadedFlag'
order by tableName, columnName

" That returns a list of the tables that Contain the 'UploadedFlag' Column.   I have testing the SQL on both HeidiSQL and SQLite Expert Personal applications and run and return what I expect, however when I run it through LabVIEW I get a 402860 Error with the description " SQLITE_ERROR(1): near "(": syntax error " 

If anyone could point me in the direction of the syntax error then I would be very greatful.

Regards

Mark

I am using  NI_Database_API.lvlib on Labview 2017. I am tringot insrt multiple rows into table but I have the error : 'Semicolon seperatot is missing at the end of the query.'

Plaese find below my command to insert two rows onto one table T_Column ( C_Name as String, C_Status as String).

INSERT INTO T_Column (C_Name , C_Status)
VALUES('21' , 'Not realised'),
('22' , 'Not realised');

How do I must modify the query? Is it possible to insert multiple rows using Microsoft.oledb.4.0?

Thanks for your help.

I'm having a hard time to get the position of a found text in a Word file. I'm able to use the Report Generation toolkit to search+replace text, but I want to highlight the replaced text one way or another. Using the "track changes" option of MS Word would be the best, but changing the font of the replacement and leaving the original text too would also suffice.

The reason I'm struggling with it is that there are several text to search for and replace and the texts are sometimes contain other search text (so for example I want to replace X01 with Y but X01.01 with Z). This can be solved by sorting the search texts reversed alphabetically.

Since I can only search and replace, I have to turn off Track Changes (because the original text will be found again), and replace the found text with a trackable unique dummy text first, than I have to search and replace those with the original+final texts. This means Track Changes will not be effective (or the user would see the horrid dummy texts too). So I would at least apply a different font to the replacements, but I don't know how to set the "Format" parameter of the Document>Range>Find>Execute method.

A preferred method would be to get found ranges first, exclude found ranges from the next searches, then delete the ranges+insert the search string in place of them. This way the changes of the document would have a very nice highlight.

Thanks for any hints or better approaches in advance!

This time I have the following problem:

I want to do simple queries on a small .accdb as a part of a simple tool application. Labview's connectivity toolkit method works fine as far as every user is on the same Office bitness (32 vs 64 bit). But in our case, some machines have 64 bit Office and some 32 bit. This results in driver compatibility issues and our IT policies are so strict that in the near future our local admin rights might vanish too, making driver install requests for a simple tool is too tedious. This 32-64 bit transitional state can last for several months and I would prefer to have a general solution than to make 32bit and 64bit builds (as far as I know this would also solve the issue, but I'm on 32 LV at the moment).

Since loading the whole database is an option (the whole file is just 2 MB at the moment and it won't grow in the near future when hopefully all collagaues will be on the ame ground), I'm hoping there's a more "platform independent" (office and Windows 7/10 are given) solution to read the contents of .accdb files.

My googling yielded solutions for SQL database access.

Thank you for any hints in advance!

I'm new to the forum and I have a strange issue with reading TDMS custom properties with Labview.

Creating user properties is working fine using TDMS Set Properties.vi, but I can't read them with TDMS Get Properties.vi. I can read the "standard" properties, and also I do see the properties in DiAdem (dataportal and using script) and also in Excel when I use TDM(s) importer. The property names are not listed when calling TDMS Set Properties.vi without the property name and data type terminals connected.   

There is no simultaneous file reading or writing.

I solved the problem with loading DiAdem and running a script, but that's very slow and also not all target machines have DiAdem installed (and no licence either, obviously).

I also tried with property names such as User Properties\Device_ID, User_Properties/Device_ID in whatever combinations (I look for the property "Device_ID") without success.

Thank you for any hints in advance!

I've put together a subVI that writes a row of data to an Excel worksheet using ActiveX. It works fine but it's a bit slow. It takes a few seconds for the VI to complete, although the row only has a few tens of columns. This is not a show-stopper but it doesn't give the user a slick experience in the top level VI that the subVI's used in. I was wondering, if I attempted the same using ADO would I see a significant improvement in speed? If you're thinking why don't I just try it, it's because I'm rather new to ADO (and ActiveX for that matter) and it would take me a while to get an Excel ADO solution going for myself, although I successfully use ADO to communicate with Access. I don't mind doing my own donkey work but it'd be nice to get some speed comparison information between the two approaches from those more in the know than myself before I attempt to flog a potentially dead horse. As ever, many thanks.

Regards.

Heavy samples and variables data compression and storage.

Who has the rights about a file format? 3 years ago I was enquired to open IBA file format.

I have nothing against germane arrogance but I believe that file format has no Copyright.

I Know that IBA (www.iba-germany.com) has a good product, better than signal express. I have the entire library to write and read IBA files using LABVIEW. The main problem is that IBA claims that they have the copyrights. I´m after LABVIEW engineers to share my knowledge and create a group to make an open source tool like IBA. I can increase IBA compression performance but it will be no longer compatible with IBA Analyzer. I´m also after copyrights support people to avoid problems with IBA Company.

My idea is to create a protocol to exchange industrial process, biological waveforms etc. across network based on a distributed database. I intend to start it based on IBA-PDA and IBA-ANALYSER.

The biggest problem with IBA is the need of access big files instead of a protocol to access only the required data at the desired sample. Tools like PIMS does not work fine with fast sample data and I have seen several engineers like OSISOFT ones trying to do it with no success.

Please contact-me if you know what I´m talking about and let´s start to create a big tool.

I have a normal text file .

Is there anyway to create .json file using that txt file from labview?

Thanks.   -Joe

Is there a way to connect with a any database on NXG 2.0 - NXG 2.1, or another solution to store the data and retrieve it?

Thank you.

Would appreciate any help/links

My company has a software/hardware product which is deployed as a labview executable. The software is of the SCADA type and it typically monitors and controls 5-20 machines using modbus. We also log data from each machine (every ten minutes, 10-20 data points per machine). The gui allows the operator to trend data in 24 hour increments by selecting the machines and day of the year. We have been using DSC and Citadel to store the data as traces which allows us to locate the data with a start and stop time for display. However, my company is not happy about the licensing of DSC and has asked me to look into other options. 

Part of the issue with DSC is that although it is supported by NI, it is no longer being developed, fixed or improved. An example of this is the DSC modbus IO servers which map to shared variables. There are known issues with how certain write functions are implemented which make it impossible to write to many modbus devices. NI has acknowledged the problem but is not going to fix it. So we have developed our own modbus routines, making use of the NI modbus library.

On the data logging and trending side, I would like to know if there are reasonable alternatives within the labview environment that don't require a DSC license on each deployed machine? I know that citadel uses TDMS and it seems like a great format, but I'm not sure if it would be too much work to build out code for logging and retrieving time series data using the low level functions that labview provides. As you can probably tell, i'm familiar with labview but don't have a lot of background in databases and data management.

Does anyone have experience trying something similar?

Thanks

I am currently learning LabVIEW Database which I had encountered the error stated on the title. I am using Xampp software for the database. May I know what is the problem behind this? Despite I had provided name for my table. Thank you.

States Control.ctl

User_Info.vi

Does anybody know about this? Obviously my code is way more complicated and the read and write operations are done in different unrelated VIs and in an asynchronous manner. So it seems my only way to fix this is to add a locking mechanism such as a FGV2... However, the file I'm manipulating is actually an INI file and I manipulate it using the native Configuration Data palette, which deep down relies on the R/W Text file VIs. So the FGV2 would need to be added to the native Configuration Data VIs if I wanted to have a generic fix...

The attached VI is saved for LabVIEW 2015.

Read-Write TXT issue.vi

Starting off... Currently using files for local test record storage, but also use SQL Server to aggregate data.

I am a new user to LabView and this is my first project using it. The project requires me to read a massive spreadsheet from Excel into LabView and then allowing the user to do the following:

- Select which columns to plot against the first column

- Use a cursor to select a portion of the spreadsheet: the Vi will then average the selected data by column (in other words, if the user selects data across multiple columns, the program will average data in each column separately). Then write the averages to the csv file.

So far, I have the spreadsheet read into a table as strings (because the first row of the spreadsheet is words). I have spent a lot of time searching how to allow the user to select data on the table to perform operations on, but to no avail. I am hoping you guys could give me some insight on how to tackle this project.

I have a vi, where after closing the file there is a check if some parameter has changed, so that the filename should be changed accordingly.

What is done is simply create a new path with the current parameters, and check this path with the original path of the saved file. If both paths are identical, nothing is done. If the paths are different then the file is renamed with the "Move" VI.

The vi works as expected most of the time, but where the executable is installed by a customer, error 10 is returned occasionally.

I do not understand how this can happen: if the path is duplicated then the result of the comparison should avoid the file name change.

In case that another file with the same name already existed, the returned error would then be different.

Any hints of what could be happening are welcome.

Thank you.

Regards.

Can't find any recent topics about this subject or topics at all. My need is to read a list of measurement equipment data from Microsoft Sharepoint using LabVIEW. Only answers that I could find is that I would need to read the HTML code from the pages or just access some files that are stored in the sharepoint directories, but I think these files will not include the needed metadata for the measurement equipment, calibration dates etc. Is there any reasonable way to interact with sharepoint via LabVIEW or atleast to be able to read the data from sharepoint?

does any one have worked with Infor VISUAL ERP databses?

Can they be read or written using Labview either way using database connectivity toolkit or .net libraries?

thank you

I seen that there is a Read JPG from File and Read BMP from File which can do exactly what I want but it won't accept .ico files.

I've thought about opening an ActiveX object with a web browser to display the icon but I'm not satisified with how it looks.

Also this needs to be dynamic, so a copy and paste into the front panel won't cut it. Any comments are appreciated. Thanks.

What do people use for database connectivity?  What would you recommend?

— James

I need to be able to insert and retrieve a timestamp into an SQL database with miliisecond precision (ideally three digits of precision).

Complicating the issue is that my final system is going to be hosted in a MS-SQL (so T-SQL) DB, but I am testing locally using a LAMP stack.

I have done quite a bit of digging, it seems T-SQL would like me to use datetime2 type, but this is not available in MySQL. Apparently I can should use DATETIME(3) as the type. I am struggling to create a table with this as a valid column. I am using a LAMP VM appliance which I believe is running the a version of MySQL that supports fractional timestamps, but the SQL statement to create the table is failing.

CREATE TABLE t1 (t dt DATETIME(6));

Any ideas what I am doing wrong?

Secondly, it looks like the NI DB Toolkit has very primitive support for timestamps, and people prefer to use strings? Can anybody share their current "best practice after having done it wrong a few times" with me? Beer on me for solutions 

Thanks 

I am looking for a toolkit which would allow to connect and modify the hosted db from LV application. 

What are the options? (excluding the Database Connectivity Toolkit). 

max

I want to go from TestStand's output i.e. database to HTML5 SPC charts. Sorta like http://moderndata.plot.ly/using-plotly-from-labview-via-python/ Has anyone done this or used Bokeh or Enthough's data tool before?  What about these tools with TDMS or HDF5?

Thanks. I appreciate it.

Best,

Pavan 

By the way, https://www.enthought.com/services/consulting/case-studies/TAIPAN/ (like TestStand without TestStand)

I am trying to implement SQLite - update function so i can easily modify values in a selected row. 

http://www.sqlitetutorial.net/sqlite-update/

I have tried this statement - UPDATE ESD_User SET Name = 'James Bond', Status = 'Employee', Location = 'Canada' WHERE EmployeeID = 5;  using the DB Browser for SQLite. The command does update the values as expected. 

I am trying to do same with the labview + sqlite driver. I have attached the update user code. 

I am getting an error from EXEC SQL

"SQLite.lvlib:Connection.lvclass:Execute SQL (Single String).vi:760001:Step on "UPDATE ESD_User SET Name = 'James Bond', Status = 'Employee', Location = 'Canada' WHERE EmployeeID = 5;"

SQLITE_BUSY: database is locked."

Can you please explain the cause of this error? 

Thank you, 

max

Please provide me better option.

I had a problem with my long time messurment. The programm crashed and it did´nt close the tdms file. There is sadly no way, i can repeat the messurment. Is there a way to recover the file? 

The storage was formated in FAT32, that is the reason why the programm crashed at 4 Gb filesize.

Thanks for your help.

Using a sine signal input I attempted to insert 50 rows in one iteration, but every method I tried returned 50 values in one row. Using the end of line constant and array to spreadsheet string, returned what looked like 50 rows, but when I queried "SELECT COUNT(*) FROM.." the no of rows was equal to the number of iterations.

On another forum post, someone suggested it is not possible to insert multiple rows using the DBCT. Can anyone confirm this?

I have written some code which allows me to insert 3 rows in one iteration, under a single connection. However, this method is very tedious and wouldn't work for large amounts of data.

Can anyone think of a better way to do this?

Thanks in advance,

Lisa

I'm working on modifying some old LabVIEW code for an internal customer where reports generated by the compiled EXE are essentially LabVIEW FPs that are printed to a PDF printer.  I've been asked to streamline the process by preventing the prompt for filename/location for each report that is "printed", (and there are many) as well auto-generate the PDF filenames. 

The problem I've run into is that in using the LabVIEW PDF toolkits that I've found on VIPM and NI's website - the FPs are added to the PDF files as images whereas by using a PDF "printer" to print the FP, it appears that an OCR engine is used to break up the FP image into images and searchable text.  Having searchable text is what the customer wants to keep if possible. However, with the level of control they're requesting for PDF generation, I'm having a difficult time finding a solution that can be done in LabVIEW and meet all of the requests without changing the report generation scheme from FP "printing" to an actual proper report scheme... which they don't want me to do. 

I could dig into finding out more details about programmatically controlling their "PDF Printer" from LabVIEW, but I would prefer the application not to be coupled too tightly to a 3rd party application that could change or disappear at any time. (Gov't Contractor).

Anyone have any ideas?  It would be nice if the available PDF toolkits out there had some sort of OCR function for images if they contained text.

If this is too much of a pain to do, I may just have to tell them it will have to be one way or the other.   I love LabVIEW programming, so if I can do it I will.

I've place a timer outside the while loop and subtracted it from the timer inside the loop, using shift registers to carry forward the start time. I place the timer in a sequence structure to make sure it starts before the code runs.

When I used this method on a simple example - a while loop with wait function, the loop execution time returned the wait time as expected. But in the database application, the loop execution time value continues to increase. Where am I going wrong?

Thanks in advance,

Lisa
 

I also want to be able to read back data from previous experiments and replot on a similar graph. 

Reading threads on this forum and at NI I'm uncertain if I'll be better pursuing a set of TDMS files, probably one per sensor type stored at the group/channel level, then at the end of an experiment, collating the TDMS files into one master file and defragmenting, or trying instead to write to a SQLite database. (I have nearly no experience using SQL, but no problem learning - drjdpowell's youtube video was already very informative.) An alternative possibility mentioned in a thread somewhere here was to write TDMS files, then store records on which files hold what data in what I understood to be a catalogue-style SQL database.

Could anyone with a clearer idea/head than me comment on which avenues are dark tracks down which time will be easily lost in failed attempts, and which seem likely to be worth trying?

Background: I'm currently rewriting some code I wrote last year based on the 'Continuous Measurement and Logging'  template/project. The logging in that case was writing to a single, binary file. Keeping my data format in line as I changed sensor arrangement became increasingly annoying and an ever expanding series of block diagrams lead me to start on the 'Actor Framework' architecture.

I have some initial progress with setting up actors and generating some simulated data, passing it around and getting it from different formats onto a waveform or XY-graph (can be chosen by choice of child class to insert into a subpanel). I'm now looking to write the logging code such that I have basic implementations of several of the components before I try and write out all of the measurement components and so on - I already have a temperature measurement library for an LTC2983 based PCB and so can use that to test (with hardware) inputting 1D arrays, whilst I'm planning to use just the sine wave VIs to test waveform input.

I'm not so far into this set of coding that anything is set in stone yet, and so I want to at least try and start off in the right direction. Whilst it seems likely changes to requirements or plans will require modifications to whatever I write, it would be nice if those weren't of the same magnitude as the entire (e.g. logging) codebase.

Apologies for the somewhat verbose post.

I followed the following tutorial:

https://decibel.ni.com/content/docs/DOC-30308

Without access to a cRIO, I have followed the steps to create the database, table and block diagram. Please see block diagram attached.The system exec.vi calls the psql.exe with SELECT command using database "lisam" and database user "postgres".

When I execute the same code I am asked for the password for user postgres. When I type in the password, the box closes and reopens. This continues in a loop until I press abort. I get no errors and when I write the same script into the cmd - the password is accepted and the table is displayed, see attachment.

PROBLEM:

• Password request from the psql.exe file when executing LabVIEW code
• Type password, psql.exe closes and opens again
• SELECT query works without while loop (password accepted once) but insert and clear does not without the loop condition

What I've tried...

1. Created a pgpass.conf file in a postgresql folder in %AppData% in the following format:- hostname:port:database:username:password, where lisam is the database, postgres is the user.

Host name as localhost '127.0.0.1' - password still requested.

    127.0.0.1:5432:lisam:postgres:password

Host name as 'localhost' - psql.exe flashes continously and LabVIEW crashes. localhost:5432:database:username:password

Host name as database client address '::1' - password loop with the psql.exe.

    ::1:5432:database:username:password

Host name to '*' -

    *:5432:lisam:postgres:password

Able to:

• Access the database through the cmd WITHOUT password

  C:/Program Files/PostgreSQL/9.6/bin/psql -c "SELECT * FROM demo1" lisam postgres

Problems:

• Execution in Labview - psql.exe flashes continuously and the program crashes.
• Accessing database through psql.exe directly - password requested and ERROR received
  "psql: FATAL: password authentication failed for user C:\Program Files"

2.Changed the authentication method in pg_hba.conf to trust for:

• localhost (127.0.0.1)- a password is still requested.

• 127.0.0.1 AND ::1 - Can access the database on psql without a password, but the psql.exe LabVIEW completely crashes.

  3. I tried adding the host and port to the code

     C:/Program Files/PostgreSQL/9.6/bin/psql -c "%s" -h 127.0.0.1 -p 5432 lisam postgres

And the psql.exe flashes continously and won't abort.

4. The password is called at the system exec VI in the cmd. Tried concatenating the password (as a control) with space constant to the command line string inbetween the format into string and the system exec VI. But the password is given before it is called.

In summary I am able to use .pgpass.conf to authenticate the password when using the cmd, but not in LabVIEW. Does anyone know a way around this? Or another way to define the password at the system exec VI?

Your help is greatly needed.

Lisa

Info:

• database name: lisam
• database user: postgres

IPv4 local connections-

    host all all 127.0.0.1/32 md5

IPv6 local connections-

    host all all ::1/128 md5

    DB:lisam Client Address ::1
    psql Client address 127.0.0.1

I am a relatively new Labview user, and this is my First post on these forums. I posted an issue on the NI forums, but figured it wouldn't hurt to look elsewhere for help. Below is a link to my issue outlined on the NI forums, but i shall do so again.

Link to first thread:

http://forums.ni.com/t5/LabVIEW/Unable-to-delete-one-row-from-Database/m-p/3340518/highlight/false#M981003

Setup: postgresql database with table clust, in the public schema. This table has 3 columns; user, password, privilege. This table has 2 test entries; the first entry (alex, 123, 123) and second entry (mike, 456, 456)

What i am trying to do: delete one row from a table in my database.

What is happening: When i try to delete the entry alex, it deletes all the entries. When i try to delete mike, nothing happens.
Below are 2 images of an extremely simple VI running, and completing without error, except what i outlined above. Hopefully someone knows what is going on, as i really have no clue.

Thanks for reading,

StavA

Thanks!

--Hope

I'm pretty new to Labview and very new to databases. I found SQLite and thought it would be a good fit for a new project, but I'm having a hard time getting the where statements to work so I get the data I'm expecting.

Ive created a table in a database editor called parts, it has two fields part type and serial number. I scan a tag to get a serial number and would like my database call to return the appropriate part type. Right now I only have one value in each column ( a single serial number and a single part type). I tried to use the "?" and bind the serial number to it but kept getting zero returned values. I can get the part type value by saying "SELECT PartType FROM Parts".

I must be doing something very simple wrong, I tried to look on the SQLite.org but really wasnt sure what I was missing in the syntax section for select.

any help would be great,

Thanks

Since I've gleemed quite a bit of useful code and information from this site, it is my pleasure to offer what I hope is a useful piece of code to the community.

The MSXML toolkit offered through the OpenG site is a really nice implementation of the MSXML DOM Active X object but I've been bothered by the single line format that the "Save XML" vi generates. This single line format makes it near impossible to manually read/edit an XML file if it's been touched by this vi. The vi I've attached has a few lines of code added that will save the XML in a standard "pretty" format (tabbed tree structure). To use simply replace any instances where the previous "Save XML" vi was used with the new vi.

Enjoy,

Randy

Download File:post-3040-1153346994.vi

I have, during testing, created several multi-GB files which I can use for read testing.  I notice that upon first access (after loading LabVIEW) the query to get data takes sometimes exactly as long as if the file was not indexed at all.  Subsequent reads are fast (drops from 30sec to 100 msec).

1) Has anyone else seen this?

2) Is this normal (Loading Index into memory)

3) How do I make the first file access fast?

Shane

Given the case where I have 1M X and 1M Y steps (a total of 1000000M data points per channel) how do I efficiently get a decimated overview of the data?

I can produce the correct output data be using

Select X,Y,Z,Float1 from P

WHERE X=0

GROUP BY Y/1000

This will output only 1x1000 data instead of 1x1000000 datapoints, one dimension quickly decimated  Problem is that is iterates over all data (and this takes quite some time).  If I do a different query to retrieve only 1000 normal points, it executes in under 100ms.

I would like to use a CTE to do this, thinking that I could address directly the 1000 elements I am looking for.

WITH RECURSIVE  cnt(x) AS (     SELECT 0     UNION ALL     SELECT x+1000 FROM cnt      LIMIT 1000  )WHAT GOES HERE?;

So if I can create a cte with column x containing my Y Indices then how do I get from this to directly accessing

Float1 FROM P WHERE X=0 AND Y=cte.x

SELECT Float1 from P WHERE X IN (SELECT x FROM cnt) AND Y=0 AND Z=0

Using the "IN" statement is apparently quite inefficient (and seems to return wrong values).  Any ideas?

In addition, accessing even a small number of data points from within an 8GB SQL File (indexed!) is taking upwards ot 30 seconds to execute at the moment.  With 1.5GB files it seemed to be in the region of a few milliseconds.  Does SQLite have a problem with files above a certain size?

Essentially I just want to make a ring buffer stored in an SQLite database (sure, it could be any type of db) to buffer some data acquisition for use as pre-trigger data as well as a local window.  With that in mind I added a trigger to ShaunR's Data Logging Example and increased the decimation factor high enough to not decimate (didn't want to mess with the rest of the example).  The trigger code is below for a buffer of 1000 entries.  Now, this seems to work fine and not blow up the size of the db or anything with my limited testing, but are there any issues with simply deleting preceding rows and allowing rowid to continue increasing?  If there is an issue with this implementation, what proposed solutions do you have?  I could create pointers and such and manually iterate around in LV when inserting, but I really want the db to handle this and have it be transparent to my application.

I have an understanding of writing to and querying db's and use them a lot for test specs and results, dynamic field population, etc., but I haven't done much in regards to buffering or storing acquired data and am working on exploring how doing more work on the db side can make things easy on the LV side.

DELETE FROM graph WHERE rowid%1000=NEW.rowid%1000 AND rowid!=NEW.rowid;

This is a huge feature feature improvement that effectively allows transparent queries of embedded JSON strings in the DB and will be of special interest to LabVIEW web enabled applications with SQLite back-ends for direct to DB insertions and remote queries. It achieves an impressive pars speed of over 300 MB/s (allegedly)

http://forums.ni.com/t5/LabVIEW/Write-to-Binary-File-Cluster-Size/td-p/3199224

I have a cluster of data I am writing to a file (all different types of numerics, and some U8 arrays). I write the cluster to the binary file with prepend array size set to false. It seems, however, that there is some additional data included (probably so LabVIEW can unflatten back to a cluster). I have proven this by unbundling every element and type casting each one, then getting string lengths for the individual elements and summing them all. The result is the correct number of bytes. But, if I flatten the cluster to string and get that length, it's 48 bytes larger and matches the file size. Am I correct in assuming that LabVIEW is adding some additional metadata for unflattening the binary file back to a cluster, and is there any way to get LabVIEW to not do this?

We create the following:

Up to X data points for 24 channels of data interleaved in the first dimension (multichannel 1D)

Up to Y times this first dimension (making the data multichannel 2D)

Up to Z times this second dimension (making the data multichannel 3D)

So in a sense, we create 4D data.

Trying to use our old method of storing the data in memory fails quickly when the number of steps in each dimension increases.  So we want to store them in TDMS files.  But looking at the files and trying to  imagine what read speed will be like, I'm unsure how to best store this data.  DO I need multiple TDMS files?  A single file? How to map the channels / dimensions to theinternal TDMS structure?

In a further step to my efforts, I would be investigating having the routine for retrieving any sub-set of this data (1D or 2D slices from any combination of dimensions but almost always one channel at a time.

Can anyone with more experience with TDMS files give some input and help a TDMS noob out?

Can anyone help me.

I want to unzip the file that is password protected in labVIEW. It is not possible by using Unzip.vi. My OS is Microsoft 10, and I am using labVIEW 2014.

Thanks in advance.

A consequence of this decision is that someone wanting to introduce a new piece of hardware + its corresponding control code must go further than just dropping a plugin that meets the communication contract into a directory. They must implement all the file IO stuff in the file IO process.

The thought has entered my mind that perhaps it would be better to make File IO the responsibility of the plugin that wants to save acquired data. So each individual process would implement a sub loop for saving its own data. The template for plugins would then include the basic file IO stuff required so it would be much easier for someone to just modify the data types to be saved.

My goal here is ease of maintenance/extension.

The most important consideration for me apart from ease of extension is whether having a bunch of independant processes talking to the OS will be more CPU heavy than one single actor (who is an intermediary between the OS and all the other processes).

Does anyone have any experience in this area?

I am having trouble on learning what to do after you input a file into labVIEW. I cannot seem to find help on this topics. I have seen many videos and tutorials on how to read and write excel/text (.csv) files. But, I am not able to do anything after importing an text/excel file into labVIEW.

So, I was wondering if someone had a simple VI that they could share. In the end, I want to do some automation so it will read a number and a status from excel. And then that number and status will either turn on or off a switch which controls something else. 

Anyways, I would greatly appreciate if someone could share a VI as an example of how to manipulate the data to control something after you import a text/excel file into labVIEW.

i'm trying to read and write XML-Files with LabView. I figured out that JKI EASY XML helps a lot. Still i have to create a cluster describing the structure of the XML-File i want to read or write. 

I have a large XML-Schema describing the structure of the XML-File. Is there any way to create the cluster automatically? The manual work would be a lot of effort. I thought about creating the cluster dynamically but it seems to be not possible within labview. Another option could be to edit the .vi file using other software/programming language but at least with a text editor i couldn't achieve readable code. Is the file format documented?

Any ideas?

Thanks

Sebastian 

Thanks in advance for all the help.

Michael

I use a very large cluster, consisting of many nested type definitions. For this cluster, I keep the complete version history, i.e. each version of the cluster is a separate file. In this file, however, I no longer want to autoupdate the nested clusters when my typedefs change. That's why I'm disconnecting all the typedefs each time I create a new file (new version).

This takes quite a lot of time. Can you think of a simple way how to do this "batch disconnection" more simply?

Vladimir

I need to select a .csv file which has two integers seperated through a comma per line. I have to sume these to values and write it to a new .csv file with the two integers and as third position the result. I have a path selector and a read from spreadsheet and a write to spreadsheet element. But I do not know how to read the two values line per line and add those to values with the result in a new .csv file. 

For example:

input:

A,B
1,3
2,6
3,3

output:

A,B,C
1,3,4
2,6,8
3,3,6

I hope that somebody can help me.

Thanks for your help!
Greets from Austria,

Fabian

So I have an application that uses TDMS for data-logging. There's a continuous memory leak as I write new data. It's alleviated somewhat by setting disk cache high for each channel, but as I'm acquiring data continuously over long periods of time, this isn't a great long-term solution.

I've tried switching over to the Advanced TDMS palette, but I'm having a lot of trouble getting an implementation going. A single TDMS file is accessed concurrently by multiple processes. Ideally, I want each process to open its own reference to the file. This wasn't a problem with the standard TDMS palette, but I'm getting errors with the Advanced palette.

For example, error -2539 states:

"LabVIEW:  This file cannot be written to, because it is opened and locked by another thread or process. This typically happens when a file is written by a hardware driver, for example NI-DAQmx."

Is concurrent access not allowed in the "Advanced" palette? Or do I need to do additional work in the Open step to allow concurrent access?

I'm having problems with a program I've written that hangs after some period of running. The program is fairly simple but it does a lot of xml parsing so to fix the problem I'm looking for things like references that are not closed. I have found one unclosed reference in one of my subVI:s but I can't close it without breaking the program so I look to you for help.

The reference in question is the "Node Out" reference in the NI_XML.lvlib:Get First Matched Node.vi marked in the attached file CloseRef. What I would like to do is really to wire it to the invoke node (and not use the "Refnum in" there) but that does not work because somehow the reference has changed from a document reference to a node reference. If I just close the "Node Out" reference my program doesn't work (I guess it kills the "Refnum in" reference which I need later on).

Any ideas on how I could handle the matter?

Maybe this is not the cause of the program hanging but it's the best candidate I found so far.

Thanks

Martin

I am trying to log files to some tdms file in myRIO. I got the code setup in myRIO FPGA side and the RT vi (both attached below). I have the Real TIme code working but I can't seem to get the data-logging VI working (it tells me I have a lot of broken wires and methods not supported in target). Please take a look at the RT Current Control.vi code and see if there is something I am missing.

Thank you!

RT Current Control.vi

Current Control.vi

I was thinking about something that would output the text to be copied into a wiki editor along with a folder full of all images/items that need to be uploaded to link to.

To extend this page links and hierarchy could be built based on Library / Project / VIPM Package structure.

Thoughts?

   I have a problem with a spreadsheet file.

I need to import a tabulated file that contain some text fileds with a EOL inside.
I've tried exporting that file in csv with a text delimiter such as " but the problem is how to import the file makin labview recognize the text field and so ignore the EOL in the text field.

At the moment with normal spreadsheet VI's i get a new line when i have a text field with an EOL character.

Is there any solution for my problem?

EXAMPLE:

thank you!

Geppo!

it's my first post here and i wish you can help me!

l'm programming a vi that record, register every modification happened in a table(indicator from a database) 

in other words, if i want to modify the element (1,1) for exemple, of a 2D table, it records the modification and the delay between 2 successive modifications! 

the attached vi, can expain what i want to do (temps evenement) !! so my probleme here is how can i replace the controle table to another indicator table from a database! (temps evenement1)

i will be grateful if you can help me!

temps evenement.vi

temps evenement1.vi

base de donnée SS-VI.vi

If you open TDMS Advanced - Finite Asynchronously Read.vi you'll see that it asks to run TDMS Advanced - Asunchronously Write.vi first. I ran it and understood that channel 1 was being given the following values: 0,2,4,6,... which is confirmed when the Viewer opens. (and channel 2 takes 1,3,5,7,...)

However when I then ran the Read example, the values for channel 1 became 0,1,2,3,4,... so it fetched samples from channel 1 and from channel 2.

So is there a bug, or did I misunderstand how the Set Next Read Position works? I thought the channel name in input allows me to specify what channel I want to read samples from...

Your insights would be much appreciated!

The toolkit is free to use but does have restrictions on redistribution.

http://www.upvi.net/main/index.php/products/lvhdf5

In particular, I'd like to thank the members of LAVA who worked on xnodes. I've been lurking on the xnode-related pages pages for the past three or four years while slowly building up this revamped toolkit. It would not have been possible without their efforts.

I am investigating the possibility of using TDMS files as a kind of giant circular buffer that would be too big to fit in a live 2D array of some sort. Of course the other reason is to have those data saved for when the application restarts.

A single location in the application will be responsible for writing in the file. This would consist of a loop that writes either one or a few samples for all the channels at each iteration. I successfully achieved this with good performance by setting the data layout input of the Write function to Interleaved.

On the read side, few locations might need to access the files, but only on event, so this won't be a frequent operation. However it should still be fast enough since I don't want the user to wait several seconds before being able to visualize the data. My tests have revealed that this operation is slow when data are interleaved. Here are the details:

# Channels: 500 (all in one group and the file contains only this group)

# Samples for each channel contained in the file: 100 000

Data type: SGL floats (I'm not using Waveforms)

Read operation:

# Channel to read: 1

# Samples to read: all (count=-1 and offset=0)

The time to retrieve the data is 1700 ms. (3500 if using DBL, it's quite linear...)

If I generate the file with just one Write (feeding a 2D array) in Interleave mode, I also get 1700ms, so this doesn't depend on how the file is written at the first place.

If I generate the file with just one Write (feeding a 2D array) in Decimated mode, this time I get 7ms!!

It makes sense that the operation is faster since all the data to retrieve occupy a contiguous area on the hard drive.

My 2 questions are:

- Is there a way to keep Interleaved layout while optimizing - significantly - the Read performance?

- If not, i.e. if I need to switch to Decimated, how can I write one or a few samples for all channels at each operation (I haven't managed to achieve this so far).

I should mention that I did manage to optimize things a little bit by using the advanced API, setting the channels information, and reserving the file size, but this only reduced the read time by 12%.

Thank you for your help!

Currently, I have been asked to start with just one line (3 test fixtures), which can have 1000 entries each day (some days there are none).  In the future this can grow significantly to other fixtures.

IT has asked that I not run a 30 day query every day to update the rolling 30 day stats, a local cache is desired and only the previous days test data will be queried.

My current plan:

Have a folder in which each Date is a unique file.  I can List all the files in the folder, get any dates between the current date and the newest file via SQL query, then delete any files that are past the "# of Days to Store" ini file value.  This will save me from indexing through the date column of a huge file to delete old data.

In order to prevent running analysis on each date every time the historical view is called, I was thinking I could create sections in each Date file (what Quality has asked for on each date):

FPY Stats

All Data

Failure Only

SN that were tested more than once

Then when the Quality Engineer wants the past 30 days FPY, I get the FPY section of each date in the folder.

Has anyone implemented anything like this before in their application?  I am looking for ideas on how to best approach it or does my current idea seem reasonable.

I have problems with the File Dialog Express VI in executibles. It often freezes for 30-60 seconds. This behaviour is more frequent in Windows 8.1. I have found this: http://lavag.org/topic/16924-built-application-occasionally-freezes-on-windows-opensave-dialog/ but there is no solution. 

Has anyone else noticed this behavior or know how to fix it?

My name is Fedly Chan.

Currently, I am facing problem when I try to read Interbase Data on Windows 7 (that act as server).

I created program to access Interbase data on Server, with Labview Ver.4. The program could display accessed data, and also can manipulate the data (create, delete, update). The server is using Windows XP. The program access the Interbase data also from Computer that run with Windows XP.

I have plan to change the Server into Windows 7.

I tried to access the Interbase data from the Server (Windows 7).

But error message appear : "100 CINLoad dll setup error."

It seemed that I need to install the SQL Toolkids on the Server, SQL Toolkids that work under Windows 7. I tried to install SQL Toolkids (the old version that I have with me) on the Windows7, but it did not work, it said that because of the different environment.

Frankly, when I check the price for this SQL Toolkids, it's quite expensive, can somebody help me with this problem...

Many thanks,

Fedly Chan.

(jsum0702@gmail.com)

I have an error that doesn't affect the functionality of my program, so for the moment I'm just ignoring it, but anyway I would like to know what is its cause and how can I solve it, or if it's safe to ignore it.

I have a program that makes some tests and stores the data in some clusters, and then when the job is done it writes everything in a database. Then it asks if you want to start another job or end the program. Up to there everything works perfect. But if you choose to start another job without closing the program, after you complete it there's an error at the end of the database writing. The error is this:

Error 505 occurred at NI_Database_API.lvlib:DB Tools Close Connection.vi->Escritura DB.vi->Interfaz Principal.vi

Possible Reason: Open Command Object.

As you can see in the attached image, in my database writing subVI I only open connection, use two "Insert Data" blocks and then close connection. I don't have any command references to use the Free Object block, so I don't know what's wrong.

Thanks in advance for any help. 

Our application uses .NET methods to access a SQL Server Express LocalDB database. It works, since we do manage to get the records we want. But on a regular basis, the Open method of the Recordset freezes for several seconds instead of executing within a few milliseconds like it usually does.

I was able to determine that it was the Open method (and not the GetRows or the Close methods) by measuring the elapsed time as shown on the attached screenshot.

Do you know if there is a known issue? I do have the Database Connectivity Toolkit but I have never used it, is there any chance this would fix my issue?

Thank you

I am working on a project in which I need to create files dynamically, say text files for each measurement. As these files are created dynamically, these are 'owned' by created user. From the same user I can read, write these files.

But if I try to access these files from other user accounts, those accounts have only read permissions over the dynamically created files. But I need Write permissions. 

Any suggestions to help achieve this functionality is appreciated.

P.S.:This problem doesn't occur in windows 7.

Thanks in advance,

Prabhakaran.

Main.vi

i have a problem with full a memory after reading data from database. You can see a sql select brom DB, it is very simply select from dateStart to dateTo.

I was trying use "Request Deallocation" but every time when i am reading data from a mounth or more my RAM memory is full-used and never deallocated. 
Memory cam be deallocated when i quit from Labview.

Thanks for helping

Test SQL.vi