Error -2147217900

[632]

Hi,  I am using the Database Connectivity Toolkit Eval. I am trying to get my data into the database with ms access. However, i get this error.

Possible reason(s):
ADO Error: 0x80040E14
Exception occured in Microsoft Office Access Database Engine: Syntax error in INSERT INTO statement. in NI_Database_API.lvlib:Rec Create - Command.vi->NI_Database_API.lvlib:Cmd Execute.vi->NI_Database_API.lvlib:DB Tools Insert Data.vi->try1.vi

I have gone into DB Tools Insert Data however it doesnt allow me to take a look at the block diagram. Therefore, I cant locate Cmd Execute.vi. It seems that I have to purchase the toolkit in order to view the vis.

Is there any other way that i could solve this problem?

[Dennis_Knutson]

Purchasing the toolkit will not let you see the block diagram but why would you want to? As the message says, your error is with your INSERT command. Since you did not attach your code, I have no idea what you did wrong. I would suggest you look online for a sql tutorial.

[632]

I understand that the problem lies at the "insert into" part. But I could not find the terminal that lead to this problem. this is part of my VI

[Dennis_Knutson]

Try naming your table something other than 'table'

[632]

Tried, sir

[Dennis_Knutson]

You are also inserting numeric arrays into those columns. Did you test this insert with Access itself?

[632]

sorry. what do you mean?

[Dennis_Knutson]

I checked and with my version of the database toolkit, the block diagram of DB Tools Insert Data is not locked. I don't know why you can't see it. Try again and if you can, put a probe on the output of DB Tools Build Insert Query. That you show you the exact command that is trying to be executed. See if you can do the same insert with Access itself. You have not included the actual db so I have no idea how you designed the table and whether you can actually insert numeric arrays into those columns. Did you design the db?