Tuesday, November 10, 2009

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



Share:

4 comments:

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

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

    ReplyDelete
  3. menambah tinggi badanApril 26, 2010 at 1:39 PM

    mantap bos....sip dah

    ReplyDelete

You may be intersted in

Related Posts

Updating Table Containing Xml Column via LinkedServer

If you are trying to update a table containing XML column via Linked Server in SQL Server, and you are not able to, you are not alone. There...

About Me

My photo
Is an ordinary man, with a little knowledge to share and high dreams to achieve. I'd be glad if I can help others, 'coz the only thing for the triumph of evil is for a good man to do nothing.

About Blog

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.

Popular Posts

Blogroll

Followers

Leave a Message