I am using LabView 6.1 with the vi.lib\_SQL addons. In particular, when I use the Execute SQL.vi, I will receive the following error:
"Exception occured in ADODB.Recordset. The connection cannot be used to perform this operation. It is either closed or invalid in this context. Help path is C:\Winnt\Help\ADO270.CHM and context is 1240658 in Execute SQL.vi."
Code is -2146824579
I am running this on W2k SP4, MDAC 2.7.1, talking to Access 97. I cannot find the ADO270.CHM file anywhere. The ODBC connection is pointing to the correct database file.
This code is ported from LabView 5.1, and it runs fine on a NT4.0 machine talking to Access 97.
Any help is appreciated.