Hello,I am using Database connectivity toolkit to create a Microsoft access database. I am new to the toolkit. I have been reading the tutorials online and following the instructions. I created a blank Microsoft Access file with a.mdb extension. I also created a.udl data link through ToolsCreate Data Link.
In LabView and linked it to the mdb file. My VI code is attached. I get the following error when I run the program (also attached). I am not sure what causes this error. I appreciate your help.Thanks. There are several issues here:.
You said you created the mdb file manually, how did you do that?. What is the structure of the table you are trying to insert data into?. How did you create that table?. What does the connection string to the database look like?I agree with Sir Dennis that you do sound very new to databases.
Labview Database Connectivity Toolkit
Check out for some useful background.In terms of the error message you are getting, the reason for it is not only unknown, but only knowable with a lot of effort. The reason for this unhappy situation is that the DCT hides the logic that generates the error, but passes error messages back to you unmodified. Consequently, most of the errors you get from the DCT are largely useless.Mike.
Hello Mike and Sir Dennis,Thanks for the link. I will be reading it.
I am new to databases. Here are answers to your questions.1. I opened MS Access 2013, created a blank database, and saved it as an mdb file.2. The table is not created. I was trying to get LabVIEW to create the table. The VI I am creating will be testing the performace of some sensors and return a number of values with the date of testing. I need the returned values and date to be added as new rows to the database every time a test is conducted.
Labview Database Connectivity Toolkit 2013 Free
However I am trying to have LabVIEW create the table the first time a test is conducted.4. It is actualy a cluster. It has three rows and one column. They are 33,3,and 78. The title is Table. The numbers are arbitrary in the example.This is the format of the table I am trying to achieve.Table1 332 33 78Thank you for your help!