Old Easy SQL VI with Database connectivity tollkit 1.01

[csch]

When I use statements that have no return values like INSERT, UPDATE or DELETE, I receive the error -2146824584. The error source is : "Exception occured in ADODB.Recordset, Operation is not allowed when the object is closed.. Help Path is C:\WINNT\HELP\ADO210.CHM and context 0 in Get Number of Records.vi->Fetch Query Results.vi->Easy SQL.vi->SQL transaction.vi".

I found that the VI "Get Number of Records.vi" tries to get info from a closed ADO object (Recordset state 0). I modified the the VI "Get Number of Records.vi" to check the ADO object state prior to get info (see attachement). This works !!!

But my question is: Since the database connectivity toolset is at least one year old, it is strange that
nobody has already found this problem.

Does anybody already encountered this problem ???

[Labviewguru]

I strongly recommend submitting a support request to NI at ni.com/ask to clarify your situation.

I dealt with SQL for LabVIEW 5.1 and don't recall having any problems like this (at least, not that I didn't resolve easily without modification of core VIs.)

It may be a bug, or it may be a matter of implementation, but I suggest that you talk to the guys and NI to get clarification on the situation. It would be best to figure out exactly what is going on, so you don't propogate a probably implementation problem.

Good luck

[Christopher Mitchell]

NI is aware of this issue. I would suggest replacing the compatibility VI's with Database Toolkit VI's. This ensures that future versions of your application will not have mixtures of the two different types of VIs.