DB tool error - column name blank

[computrwkr]

Hello

I am getting an error when trying to use the DB Insert Data vi, "DB Tools Validate Inputs.vi->DB Tools Insert Data.vi->Fieldpoint_temp-DB.vi<ERR>Argument error. One of the column names specified is blank." I have included a snapshot of what my vi looks like. I have also verified that the connection is setup properly and works but I keep getting this error when trying to insert data.

Any help is much appreciated.

Thanks, Ian

[computrwkr]

I have spent some time running around the VI and gained some valuable troubleshooting skills from within LabView since I am still pretty new with all this.

What I have noticed, there seems to be a problem with the DB Tools Validate Inputs VI inside the DB Tools Insert Data VI. I have traced the error to this module. I do not completely understand what is happening inside this module but if someone could take a look I would appreciate it.

I am running LabView 8.2.1.

If needed, I could upload my VI that is displaying the error but it should be able to replicate in another instance.

My personal feeling is when someone has this problem, they just delete the VI and reconnect the lines since all this module does is validate and you notice the inputs are correct but the outputs are wrong.

Thoughts anyone?

Thanks, Ian

[mikeporter]

My main though is that if you are going to be doing a lot of work with databases, it would probibly put you ahead of the game to drop the DCT and communicate directly with the underlying ADO layer that actually handles the database interactions. It's not very hard, and it increases your support options. There are a couple options available, here is one I posted. It includes both the drivers and a bit on background information (and documentation).

Mike...

[mikeporter]

Nevermind... Network connection problem... Double post...

Mike...

Message Edited by mikeporter on 08-12-2007 11:14 PM

[RDR]

Hello Ian,

The following link is to a KnowledgeBase entry regarding this error:

http://digital.ni.com/public.nsf/allkb/22A45DF5C85AB3F286256CC30073C5AC?OpenDocument

It appears the 'TimeStamp' column label is most likely the cause of your error as it is a reserved word (see the last paragraph of the page).  Additionally, I would also verify the column names you have specified in the array constant do not have any spaces after the words.

-Bob