Failed to create Recordset object error

Problem Description

AspGrid throws the following error message:

Persits.Grid.1 error '800a000c'
Failed to create Recordset object.

Solution

This error means that your system has a version of Microsoft Data Access Components (MDAC) earlier that 2.5. You can verify the version of MDAC on your system by examining the version information of the file msado15.dll which is usually located in the folder c:\program files\common files\system\ado.

AspGrid requires the version of MDAC to be 2.5 or higher. To fix the error, you must download the latest version of MDAC from the Microsoft web site and install it on your system. At the time of writing this article, the latest version was 2.6.