ADO Errors When Accessing a Database

Issue Details

I am trying to write/update data to a database using ActiveX Data Objects (ADO). I receive these errors: 

• ADO Error: 0x00000001 Argument error. One of the column names specified is blank.
  

• ADO Error: 0x80000001 Argument error. The number of columns does not equal the number of parameters.

• ADO Error: 0x80040E14 The INSERT INTO statement contains the following unknown field name.

Solution

• Confirm the number of columns matches the number of data elements specified in the VI.
• Delete any blank, initialized elements in the columns input. Initialized elements will appear in full color, as opposed to greyed out. 
• Confirm that the column input specified in LabVIEW matches the column name in your database table. 
• Confirm the data type of the inputs specified in the description of the VI (Refer to the detailed help for the VI). You can try to use the cluster datatype to avoid this kind of issue.

Additional Information

Unfortunately, these messages come directly from the Microsoft ADO layer, which means LabVIEW has no additional insight into which specific columns or data types are causing the argument, field name, or type mismatch errors.