Thread: ADO _Recordset close problem...

I am developing a client server application which will transfer an Access MDB file from the backend server to a remote client. The server is run as a service. Everything works fine EXCEPT when I add records to the MDB file and then close the file. The close statement has a tendency to crash the server. I've tried googling on the close statement but couldn't find anything relating to problems with it. Listed below is the code fragment for your review. The recordset->Close() statement is the source of the problem. Any help would be greatly appreciated.

Thanx

Bob

Code:

ADODB::_ConnectionPtr connection;
hr = connection.CreateInstance(__uuidof(ADODB::Connection));
if (FAILED(hr))
{
    throw _com_error(hr);
}
ADODB::_RecordsetPtr recordset;
hr = recordset.CreateInstance(__uuidof(ADODB::Recordset));
if (FAILED(hr))
{
    throw _com_error(hr);
}
_bstr_t strcnn("Provider='Microsoft.JET.OLEDB.4.0';"
    "Data source = ");
strcnn += szDatabaseName;
connection->Open((const char *)strcnn,"","",ADODB::adConnectUnspecified);
memset(szInsert, 0, sizeof szInsert);       
sprintf(szInsert, "INSERT INTO DELFILE3LOG VALUES ('%s','%s')",szTimeStamp,szLogRec);
recordset->Open(szInsert, connection.GetInterfacePtr(), ADODB::adOpenForwardOnly,
	ADODB::adLockReadOnly, ADODB::adCmdText);        

	recordset->Close();

	additional code.....

The error message I get from the close statement is "Operation is not allowed when the object is closed. I believe I resolved the problem by using the following if statement for the recordset close() statement:

Code:

if(recordset & recordset->State == ADODB::adStateOpen)
   recordset->Close();

Thus, we only close the recordset when it is OPEN.

I'm under the impression that the recordset would still be open after initial recordset open statement. But apparently this is not the case. Thus, we have to check to determine if the recordset is open prior to closing it. Can anybody explain this to me???

Thanx

Bob

I've wrapped the complete function in try/catch statements and the only anomalistic message I get is "Operation is not allowed when the object is closed" when I do NOT check for a closed condition on the recordset prior to my attempt to close the recordset. Evidently, the Open statement is working properly.

I've been stress testing the back end server for over 20 hours now without encountering any problems. I'm now checking for a closed condition on the recordset prior to attempting to close it. This appears to solve the problem. I guess I'll never really know why I have to check for a closed recordset even though I just opened it for updates.

Thanx
Bob

Yes, that's right, I'm doing an INSERT INTO which causes me grief. I'm an old school C programmer who's accustomed to opening a file prior to doing anything with that file and then closing the file. I guess this "old dog" will have to learn new tricks with ADO.

Thanx!!!!!

Bob