No More Solutions

You can find a lot of debugging and deploying problems while developing applications in .NET and Visual Basic here. There are also some querying tips in SQL and typical source codes which might be useful shared here.

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



Bookmark and Share

4 comments:

  1. sephtian said...
     

    hai.. link kamu sudah kupasang di blog aku.. link balik ya.. thanks..

  2. batu permata said...
     

    trima kasih banyak mas,,,saya sudah mencobanya dan berhasil...

  3. Steven Luck said...
     

    Sama2 ^^ Senang dapat membantu :)

  4. menambah tinggi badan said...
     

    mantap bos....sip dah

Post a Comment