Error executing the query in Visual Web Developer 2008

Asked By Charlie A Morse 10 points N/A Posted on - 09/13/2013

Hi,

I am a web developer and started my work including a new web site with VS 2005 and added a sqldatasource and connect with the AdventureWorks sample database. I checked the connection working fine and save as “AdventureWorksConnectionString”. At the end I received an error message while testing query with 'test query' button . How can I remove this error? If you have any idea please share some ideas. Thanks.

Visual Web Developer 2008 Express Edition

There was an error executing the query. Please check the syntax of the command and if present, the types and values of the parameters and ensure they are correct.

Invalid object name ‘Product’.

• Status: Open
• Question Views: 728
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: ProgScripting Languages

Answered By Merry Hock 0 points N/A #183451

Error executing the query in Visual Web Developer 2008

Hello Charlie,

I think you are getting this error message because of manual construction of the SQL select statement. I would advise you try the Query Wizard to build the select statement. Usually, the syntax is fieldname.tablename, maybe this is why you are getting the error. Also, when you use the wizard, most of the syntax based errors are taken care of.

About Merry Hock

Questions
0

Answers
99

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 11/12/2013
• Question Category: ProgScripting Languages