We used ADO (ActiveX Data Object) recordsets with LabWidnows/CVI 8.1.1 to store test data into SQL database. We used to store test data based on the unit and have no problem. That means we tested units and store data one by one. But this time, we have to store data based on several units test data while they are being tested. In other words, one test has multiple steps. Several units are hooked up to PC and have to go through this test. At each step, each unit's test data is recorded into the database. I think this is not unusual. However, uur observation is that after first few unit test data is stored into the database, it came up with this error message: "[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'Testing_Dept_DB'" at the functional call ADODB__ConnectionExecute. Then when we tried to retrieve that data using ADODB__RecordsetGetRows after calling ADODB__RecordsetOpen, ADODB__RecordsetGetRows came up with the error: "Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record." . It came up randomly.
I searched the Internet and came across the Microsoft website:
http://support.microsoft.com/kb/836863. It seems to be a memory leakage associated with ADO recordsets. My MDAC SDK is 2.8 and Vbscript.dll is dated on 11/7/2006 which is deemed good per this Microsoft's article. My OS is Windows XP SP2.
My question is: does NI fix it accordingly in its products like LabWindows/CVI or ADOxx.fp too? Can anyone help me out?
Thanks a lot.
