ASP error ’80020009′ when you retrieve data from SQL Server

(TechNote – update) The following error may occur when you access a recordset in an ASP file that contains “text” or “ntext” datatypes from a Microsoft SQL Server table:
Microsoft OLE DB Provider for ODBC Drivers error ’80020009′