Ado command object returns method 'Execute' of object '_Connection' failed

Error: method 'Execute' of object '_Connection' failed

Solution: Check the query used while executing the recordset, it may contain keyword used in the database. In my case, my query is:

select languageid, language from masterlanguage order by languageid

The error occurs because I use a keyword in the query, i.d. language.
To fix the error, either change the column name on the database, or use []:

select languageid, [language] from masterlanguage order by languageid