Connection issue in MS access throught labview

[KartikPatel]

Hello, 

 I am using MS Access 2010 and Labview 2012. when I am running vi of Create table and  insert column but  I am getting a repetitive error which is shown in images. 

Please help me resolve this problem.

[Yamaeda · Accepted solution]

If memory serves, you need to have column names in brackets if using spaces [Unit under test] [Test result] and so on.

/Y

[Rodéric_L]

When wiring a cluster you might need to set the column informations first. Check the examples shipped with LabVIEW (sixtypes Insert.vi)

[KartikPatel]

Hello,

I am trying to create the new table in MS Access through LabVIEW. In that table, I want to insert the array of data in the at data terminal.but error displays repetitive which shown in attached image. what can I do to resolve this error .

In MS Access, I want to do numbers of records under one field name(Array of data). and that is for more than one fields.

[dkfire]

That error tells you what is wrong, the data you are trying to store in one of the columns are too big for that column.

How have you created the table and what data type are the different columns?

You should be able to see that in MS Access.

And one tip, you don't need to wire the N terminal of the for-loop when you have some auto-indexing input tunnels on the loop.

[KartikPatel]

Hi,

I make  the datatype of both string array to text to a field to 255.and Numeric array to Double in MS Access.

but this problem still persist.please help me to resolve this error.

[dkfire]

Can you attach your vi and database?

That will help us help you.

[KartikPatel]

PFA for the BD of my VI.

[dkfire]

There are some minor issues with your programming.

Why do you have the sequence structure ? use the error wire to force data flow!

Why are you opening and closing the connection to the database multiple times in the vi?

What is the sql query that you what to run at the last connection?

I have run your vi with a new database, and I got no errors.

I have attached the database and dns file for connection info.