Error 504, associated com objects

[Nathan@home]

Hello!

I have a "DB Tools Close Connection" vi that is throwing an error 504. When I open the vi, there are notes. One of the notes says, "The Connection object is always closed and deleted, but if it had associated objects,
then report an error indicating that." 

The 504 error means it has associated objects... What is an associated object?  Thanks! -  John

[rolfk · Accepted solution]

It means that you have created recordset objects (most likely for queries) on that connection that you didn't close explicitly before attempting to close the connection.

[Nathan@home]

Thanks Rolf, Any suggestions on how to make this error go away? - Nathan

[rolfk]

Let's see.....

How about closing those recordsets with the according "close recordset" function or whatever it is called, every time you are finished using such a recordset?

[Nathan@home]

Hi Rolf,

I will export a section of code so that I can provide a zip file for your examination. I need a few days to complete. Thanks for your comments. - John

[chethanspring]

Hi Rolf,

I am using LabVIEW 2015 and I encountered same error. I found no function to close record set. Could you please post the solution for this?