LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

error -2147217900 while using database connectivity tool in labview

Solved!
Go to solution

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..

 

0 Kudos
Message 1 of 5
(4,520 Views)

Hi,

 

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

 

Regards,


Nitzz

0 Kudos
Message 2 of 5
(4,519 Views)
Solution
Accepted by topic author Sumithra_Nagappan

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

0 Kudos
Message 3 of 5
(4,516 Views)

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

0 Kudos
Message 4 of 5
(4,515 Views)

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.)

CLD; LabVIEW since 8.0, Currently have LabVIEW 2015 SP1, 2018SP1 & 2020 installed
0 Kudos
Message 5 of 5
(4,490 Views)