labview database connectivity error

[dola]

i am using labview database connectivity toolkit and when i start the vi it gives me this error     Error -2147217900 occurred at Database.GPIB:Conn Execute.vi->Database.GPIB:DB Tools Create Table.vi-

anyone can help ??

[mikeporter]

With the DCT it is always hard to tell, but that error might indicate a mismatch between the way you have the table defined and the data you are trying to put into it.

What is the table definition?

Mike...

[mikeporter]

Never mind the last comment, I just noticed that you are creating the table. You are defining two string columns but the data size is 0. Also how long is that table name?

Mike...

[dola]

the size in not a problem , also the table name isnt a problem a tried alot of names , o think the problem is with the data link !

[Dave_Brandt]

If you are using a UDL file you can test your connection to the database without labview.  Also, you have to have all the security authentication. I usually test all sql commands in the database manager tool and cut and paste text into my vi's.  This helps when connecting to different databases because the text is not always the same.  (Sometimes "text "   or 'text ') and other small differences.

[mikeporter]

The problem with the data link being at fault is the error message you are getting. The message is coming from the database. Have you tried different column names? "time" might be a reserved word. Are there just the two columns?

Mike...