Database and SQL (datalogging)

[Dennis_Knutson]

You really need to turn on Context Help and read the desciption of the functions. If you wire a path to a UDL file to the 'connection information' input of the DB Tools Open Connection function, it will use that UDL file.

[hlod]

Yes I know that, but I want to know:

 After that will be logging my input to this .udl ?

How can I then for example show this data from this database, I just read again this .udl?

[Dennis_Knutson · Accepted solution]

You will log the data to the database that is specified in the udl.

Read the database with the functions in the toolkit. You don't have to call the Open Database Connection again unless you have closed the connection.

[Yamaeda]

"Then only way is to create "udl" with MS Access(this one I have installed), and then change path in .vi to this udl"

I generally create an empty file with Databasename.udl and double click it to change it's setting. Easy and works great.

/Y 

[hlod]

Ok I created, in microsoft services new databasse(.mdb) and also create test.udl, which I link with my database.mdb; connection test was succesfull;

Now I went to labview and change path to this created UDL; but after stopping and opening .mdb with access nothing was in;

[Yamaeda]

How did you test it, with your previous program? Post the vi, are you certain it executes the Insert at all? Run it in highlight mode.

/Y