Error with database

[NightKoh96]

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.

[Karthiga]

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

[NightKoh96]

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.

[Karthiga]

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.

[Borjomy]

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.

[NightKoh96]

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.

[JensG69]

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

[njacacia]

Don't waste your time with this.

The OP can't bothered to troubleshoot his own code.

https://forums.ni.com/t5/LabVIEW/ADO-Error-0x00000001-Argument-error-The-table-name-given-is/td-p/37...

[JensG69]

Thanks for the link. As the Database test.vi still has no connector pane in that thread, it's probably the same problem. VI is started several times manually, and the DB-refnum does not persist.

Regards, Jens