data problem
-
hello i am new to this and i am doing my assignment with vs2003. I need to create simple one page web project in vs2003 with one datagrid so I connect to northwind database in server ex. in vs 2003 and then drag a datagrid and then genereate dataset and configure dataset with database but when i run the project it gives me error Server Error in '/WebApplication3' Application. -------------------------------------------------------------------------------- The SELECT permission was denied on the object 'Employees', database 'Northwind', schema 'dbo'. 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: The SELECT permission was denied on the object 'Employees', database 'Northwind', schema 'dbo'. Source Error: Line 192: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Line 193: 'Put user code to initialize the page here Line 194: SqlDataAdapter1.Fill(DataSet11) Line 195: Line 196: End Sub Source File: c:\inetpub\wwwroot\WebApplication3\WebForm1.aspx.vb Line: 194 Stack Trace: [SqlException: The SELECT permission was denied on the object 'Employees', database 'Northwind', schema 'dbo'.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) WebApplication3.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication3\WebForm1.aspx.vb:194 System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain() -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.2443; ASP.NET Version:1.1.4322.2443
-
hello i am new to this and i am doing my assignment with vs2003. I need to create simple one page web project in vs2003 with one datagrid so I connect to northwind database in server ex. in vs 2003 and then drag a datagrid and then genereate dataset and configure dataset with database but when i run the project it gives me error Server Error in '/WebApplication3' Application. -------------------------------------------------------------------------------- The SELECT permission was denied on the object 'Employees', database 'Northwind', schema 'dbo'. 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: The SELECT permission was denied on the object 'Employees', database 'Northwind', schema 'dbo'. Source Error: Line 192: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Line 193: 'Put user code to initialize the page here Line 194: SqlDataAdapter1.Fill(DataSet11) Line 195: Line 196: End Sub Source File: c:\inetpub\wwwroot\WebApplication3\WebForm1.aspx.vb Line: 194 Stack Trace: [SqlException: The SELECT permission was denied on the object 'Employees', database 'Northwind', schema 'dbo'.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) WebApplication3.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication3\WebForm1.aspx.vb:194 System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain() -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.2443; ASP.NET Version:1.1.4322.2443
The error message says it all, the credentials you are using don't have SELECT access to the table. Use different credentials or add the rights to the user in Sql Server
I know the language. I've read a book. - _Madmatt
-
The error message says it all, the credentials you are using don't have SELECT access to the table. Use different credentials or add the rights to the user in Sql Server
I know the language. I've read a book. - _Madmatt
-
hello sir thanks for your rep. as you mentioned but i dont know how to do it so could you please tell me how to do it waiting for your kind help thanks
Don't know how to do what? Use a different connection string? Change permissions in SQL Server? If it's the former, then you need more help than just that. If the latter, then contact the SQL admin.
I know the language. I've read a book. - _Madmatt
-
Don't know how to do what? Use a different connection string? Change permissions in SQL Server? If it's the former, then you need more help than just that. If the latter, then contact the SQL admin.
I know the language. I've read a book. - _Madmatt