error -2147217900 while using database connectivity tool in labview

[Sumithra_Nagappan]

hai..im new to create database..with the help of examples available im getting some ideas..even though when i try to create a table i get errors which is attached with this thread..kindly anybody give suggestion to create database using the tool kit or suggest resources link to do..

[NitzZ]

Hi,

Can you post your code or part of a code.?

Regards,

Nitzz

[Sumithra_Nagappan · Accepted solution]

i got it..i was trying to create a column  Pass/fail,i did mistake here..and corrected it..have to use pass_fail

[Sumithra_Nagappan]

But i couldnt insert special characters like "/,-,(,)"..do you know how to do this?

[James_W]

look for the valid SQL parameters and you will find that you cant use the characters you want to use.

Columns names must:

1) be Alphanumeric

2) Start with an alpha character (not allowed a column "10_bar_pressure_test"

3) the only special character I have found so far that is allowed is underscore  - i.e. no spaces, commas exclammations full stops or other things.

Hope this answers your question. (Basically it is a limitation of SQL programming, not LabVIEW and you must work around it.)