10-25-2017 02:09 AM
Greetings,
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.
10-25-2017 06:28 AM
Hi NightKoh96,
Please check this link (https://forums.ni.com/t5/LabVIEW/ADO-Error-0x00000061-Unknown-System-Error-in-NI-Database-API/td-p/3...). It may help you!
Regards,
Karthiga
10-30-2017 02:58 AM
Hi Karthiga,
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.
10-31-2017 01:09 AM
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.
Regards,
Karthiga.
10-31-2017 02:24 AM - edited 10-31-2017 02:25 AM
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.
11-02-2017 10:04 PM
Hi Borjomy,
Can you show me how you put a probe at the "Insert Query" in the "DB Tools Build Insert Query.vi"? Thank you.
11-03-2017 08:18 AM - edited 11-03-2017 08:19 AM
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.
Regards, Jens
11-03-2017 08:46 AM
Don't waste your time with this.
The OP can't bothered to troubleshoot his own code.
11-03-2017 11:19 AM