LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Error with database

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.

 

 

Download All
0 Kudos
Message 1 of 9
(1,920 Views)

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

Message 2 of 9
(1,885 Views)

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.

0 Kudos
Message 3 of 9
(1,857 Views)

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.

Message 4 of 9
(1,834 Views)

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.

Labview 4.0, 5.0, 6.1, 8.6, 2009, 2011, 2012, 2014
If you do not know something, ask me.
Message 5 of 9
(1,826 Views)

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.

0 Kudos
Message 6 of 9
(1,780 Views)

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

Kudos are welcome...
0 Kudos
Message 7 of 9
(1,765 Views)

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

0 Kudos
Message 8 of 9
(1,761 Views)
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
Kudos are welcome...
0 Kudos
Message 9 of 9
(1,754 Views)