I am learning on database which I encountered the error stated on the title. I couldn't troubleshoot the error. I have attached the files and image of error to this thread. Thank you for your help.
I am using Xampp software for database, ODBC 32bit for creating UDL file.
Sorry, I don't understand the link you provided as I am revising/learning for my LabVIEW which I used since last year. By the way, today I tried again and I get different error. The following error, I have attached a screenshot to my reply.
I think, someone had the same error as you and they were discussing about that error in that link which I provided. But still, you are getting a different one like - "The table name given is blank".
As they already quoted in that link, you can try with giving table name, a default value. (Data operations -> Make current value as default)
Because, if you did not give any default value as your table name, it would be reinitialized to empty string during next execution. It may be the reason for your error.
For the future. Go inside the "DB Tools Insert Data.vi", find the output "Insert Query" in the "DB Tools Build Insert Query.vi" function and put a probe there. Here you will see the body of the SQL request. Then many questions you will disappear.
How do you use your VI "database trial 1.vi"?
I assume that currently you use it "manually", i.e. you select the Enum-Value and then run the VI once, since the connector pane is empty... Am I correct?
That's a problem, because the database-connection that you open when running this VI once with enum "Open Connection" will not persist when you run the VI manually a second time, this time perhaps with the enum-value "Login". Since the connection refnum is invalid you cannot expect to get a valid responce from the database VIs you use in that case.