LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Bug Report - DB toolkit returns error when calling the DefaultDatabase property with SQLite

There's an old bug in the DB toolkit where calling the DefaultDatabase property returns error -2147217887 if you're using certain DBs (such as SQLite or PostgreSQL and I believe MySQL as well).

 

The problem is that this property is called by a VI which is used in some of the commonly used VIs (such as the insert VI), causing them to fail. Whoever wrote the code was aware of this issue, since they added a comment about it, as you can see below.

 

NI_Database_API.lvlib_Conn Get Properties_BD.png

 

The immediate fix for this is pretty easy -  add code to ignore the error or don't call the property at all. It's not used anywhere in the toolkit and unless you're using the VI yourself to get the property, this won't break any code. The problem with this is that you need to do this in every PC.

 

NI already has a CAR for this (CAR 232063) and should hopefully fix it, so there's no need to take further action at the moment. This post is for people searching for this in the future.

 


___________________
Try to take over the world!
Message 1 of 3
(3,577 Views)

This has been fixed in LV 2011.


___________________
Try to take over the world!
0 Kudos
Message 2 of 3
(3,379 Views)

Interesting. I have seen this before but it returned a different error code. (Error -2147352567)

=====================
LabVIEW 2012


0 Kudos
Message 3 of 3
(3,364 Views)