We have a developed a tool using Excel 2007 which communicates with SQL Server 2005 DB for importing / exporting data. We have used ADO to establish connection with the SQL server DB and execute stored procedures in the DB to save the data from the sheet into the tables. To retrieve data from DB too, we use ADO to execute the stored procedure in the DB and display the recordset that is returned in the sheet. This approach works fine without any issues.
But now we are increasingly facing a problem, i.e the application after being used for some time, crashes forcing the user to restart the application. This happens even when the tool is left open for some time. We were unable to determine the cause of the error, but found the following link,
http://support.microsoft.com/kb/319998, that resembles the problem we are facing.
Can any one if the mentioned bug (BUG: Memory leak occurs when you query an open Excel worksheet by using ActiveX Data Objects (ADO)) applies to Excel 2007 also?
The Error description
CiceroUIWndFrame : EXCEL.Exe - Applicaiton Error
The instruction at 0x65111497 referenced memory at 0x00000000. The memory could not be "read"
when i clicked on debug, We get the following error message
Unhandled Exception 0x65111497 in Excel.EXE: 0xC0000005. Access violation reading location 0x00000000.
at this line
65111497 mov ecx,dword ptr [eax]
Can anyone Please clarify
But now we are increasingly facing a problem, i.e the application after being used for some time, crashes forcing the user to restart the application. This happens even when the tool is left open for some time. We were unable to determine the cause of the error, but found the following link,
http://support.microsoft.com/kb/319998, that resembles the problem we are facing.
Can any one if the mentioned bug (BUG: Memory leak occurs when you query an open Excel worksheet by using ActiveX Data Objects (ADO)) applies to Excel 2007 also?
The Error description
CiceroUIWndFrame : EXCEL.Exe - Applicaiton Error
The instruction at 0x65111497 referenced memory at 0x00000000. The memory could not be "read"
when i clicked on debug, We get the following error message
Unhandled Exception 0x65111497 in Excel.EXE: 0xC0000005. Access violation reading location 0x00000000.
at this line
65111497 mov ecx,dword ptr [eax]
Can anyone Please clarify