problem creating asp.net project in visual studio 2003 with xp pro
-
hello i am new to asp.net i have created on small web project with one datagrid on page and when i drag and drop sql data adapter on page it shows error "Generated SELECT Statment" and then i have managed to solve this issue but now it showing "Generated CANCEL Statment" "Generated UPDATE Statment" "Generated DELETE Statment" so i dont know what to do now so I have tried to run the project but it also showing error Server Error in '/WebApplication3' Application. -------------------------------------------------------------------------------- Login failed for user 'MACHINE NAME\ASPNET'. 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: Login failed for use MACHINE NAME\ASPNET'. Source Error: Line 59: 'Put user code to initialize the page here Line 60: If Not Page.IsPostBack Then Line 61: SqlDataAdapter1.Fill(DataSet11) Line 62: DataBind() Line 63: Source File: c:\inetpub\wwwroot\WebApplication3\WebForm1.aspx.vb Line: 61 Stack Trace: [SqlException: Login failed for user 'DEEPAK-5WT558AI\ASPNET'.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38 WebApplication3.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication3\WebForm1.aspx.vb:61 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.2
-
hello i am new to asp.net i have created on small web project with one datagrid on page and when i drag and drop sql data adapter on page it shows error "Generated SELECT Statment" and then i have managed to solve this issue but now it showing "Generated CANCEL Statment" "Generated UPDATE Statment" "Generated DELETE Statment" so i dont know what to do now so I have tried to run the project but it also showing error Server Error in '/WebApplication3' Application. -------------------------------------------------------------------------------- Login failed for user 'MACHINE NAME\ASPNET'. 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: Login failed for use MACHINE NAME\ASPNET'. Source Error: Line 59: 'Put user code to initialize the page here Line 60: If Not Page.IsPostBack Then Line 61: SqlDataAdapter1.Fill(DataSet11) Line 62: DataBind() Line 63: Source File: c:\inetpub\wwwroot\WebApplication3\WebForm1.aspx.vb Line: 61 Stack Trace: [SqlException: Login failed for user 'DEEPAK-5WT558AI\ASPNET'.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38 WebApplication3.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebApplication3\WebForm1.aspx.vb:61 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.2
If your database is using integrated authentication (looks like it from your trace), have you defined the ASPNET user in the database?
-
If your database is using integrated authentication (looks like it from your trace), have you defined the ASPNET user in the database?
-
Hello sir thanks for your rep. but i dont know how to do it i am still searching on net waiting for your kind rep. thanks
Is this your database? Have you installed it? If not you should the ask the system administrator or whoever created this database to add you (or your aspnet user to the database. Have you ever connected succesfully to this database? Can you for example use SQL Administrator to browse data?
-
Is this your database? Have you installed it? If not you should the ask the system administrator or whoever created this database to add you (or your aspnet user to the database. Have you ever connected succesfully to this database? Can you for example use SQL Administrator to browse data?
hello sir thanks for your prompt response currently i have one small assignment to create web project with one page so it should display author table from pubs database into datagrid thats all so what i have done drag and drop sql data adapter on the web page and went through wizard to complite but at the end of wizard it shows generated error for update, delete and cancle so i dont know what to do with this and when i try to run the project it shows loging error but if i right click on sql data adapter and select priview data it shows all the data waiting for your kind help have a nice time