- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ADO Error: 0x00000061 Unknown System Error in NI_Database_API.lvllib: DB Tools Close Connection.vi
Solved!
JLuna
12-04-2015 08:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
What I'm literally doing is trying to save a bar code previously scanned. The scanner is connected to COM11 (serial port) using VISA functions. Then through a string I insert the information into a subvi that saves the respective information into an access database. The program will save in two different columns the information, depending if the barcode scanned starts with " X " or with " I ". After running the VI and scanning some barcode,the error message appears.
So my hypothesis is that the problem is within the subvi, because the message appears only when I scan a barcode, in other words: when the string is detected from the COM and inserted to the database until the connection is close, is when the error comes up.
Also very weird, when I open the subvi, and run the VI from there, the message also shows up.
But I really have no clue what is wrong... I have not much experience with LabVIEW and berly starting to know about databases and its respective connections so,
Can someone help me!! Pleaseee!!!!
Solved! Go to Solution.
dkfire
12-04-2015 08:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
How should we be able to help you, when we do not have the vi that generates the error?
You need to attach your code, so that we have a small chance of trying your code.
12-04-2015 08:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
True, I totally forgot to attach the .vi
Now I attach the VI and the subVI.
dkfire
12-04-2015 08:42 AM - edited 12-04-2015 08:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
So you do not supply the database vi, TESTBASEDEDATOS.vi, with a table and column names, how do you think it should insert your data to the database in the right table?
12-04-2015 08:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
OMG, I'm so sorry. I'm in panic right here 😞
I'm still figuring out and searching for the problem... Here it is the access 2013 file and the .UDL file.
12-04-2015 10:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
In the UDL is the one that makes the reference to the database in access. In the subvi, in the front panel, you specify the name of the new or existing table, also you name the columns.
dkfire
12-05-2015 03:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
@JLuna wrote:
In the UDL is the one that makes the reference to the database in access. In the subvi, in the front panel, you specify the name of the new or existing table, also you name the columns.
But the subvi does not have any default values, so when ever the vi is called, it has NO data in the two controls, Table Name and Column Names.
