By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,081 Members | 861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,081 IT Pros & Developers. It's quick & easy.

Invalid object name accessing SQL

P: n/a
I get the following error:

WGA_Update is a view not a Table

Invalid object name 'WGA_Update'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object
name 'WGA_Update'.

Source Error:
Line 20: objConn.Open();
Line 21:
Line 22: objRdr = objCmd.ExecuteReader();
Line 23: ddlLast.DataSource = objRdr;
Line 24: ddlLast.DataValueField = "WwgaID";
Source File: c:\inetpub\wwwroot\wga\wgaUpdate3.aspx Line: 22

Stack Trace:
[SqlException: Invalid object name 'WGA_Update'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteReader() +42
ASP.wgaUpdate3_aspx.BindData() in
c:\inetpub\wwwroot\wga\wgaUpdate3.aspx:22
ASP.wgaUpdate3_aspx.Page_Load() in
c:\inetpub\wwwroot\wga\wgaUpdate3.aspx:13
System.Web.Util.ArglessEventHandlerDelegateProxy.C allback(Object
sender, EventArgs e) +10
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750

Any help would be appreciated.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Post ur code!
"Jerry Nelson" <je**********@cachan.ang.af.mil> wrote in message
news:uZ**************@TK2MSFTNGP09.phx.gbl...
I get the following error:

WGA_Update is a view not a Table

Invalid object name 'WGA_Update'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object
name 'WGA_Update'.

Source Error:
Line 20: objConn.Open();
Line 21:
Line 22: objRdr = objCmd.ExecuteReader();
Line 23: ddlLast.DataSource = objRdr;
Line 24: ddlLast.DataValueField = "WwgaID";
Source File: c:\inetpub\wwwroot\wga\wgaUpdate3.aspx Line: 22

Stack Trace:
[SqlException: Invalid object name 'WGA_Update'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteReader() +42
ASP.wgaUpdate3_aspx.BindData() in
c:\inetpub\wwwroot\wga\wgaUpdate3.aspx:22
ASP.wgaUpdate3_aspx.Page_Load() in
c:\inetpub\wwwroot\wga\wgaUpdate3.aspx:13
System.Web.Util.ArglessEventHandlerDelegateProxy.C allback(Object
sender, EventArgs e) +10
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750

Any help would be appreciated.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #2

P: n/a

I figured out the problem, I just needed to change the ownership of
WGA_Update to dbo.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.