Thomas
12/20/2002 3:02:00 PM
Could someone please help me out, i have been hitting my
head against he wall with this MS SQL 2000 server problem.
When i run an .NET Asp project from Visual Studio .Net
using VB.net. i get this weird error.
( By the way, i'm using NT Integrated Security, on
Windows XP Pro)
The funny thing about it is that i can run the exact code
for Oracle 9 and MS Access, but when i run it for SQL
Server it bombs and complains about my DbDataAdapter.Fill
function causing the exception, and it generates this
error message:
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 user 'ARTMIC\ASPNET'.
Source Error:
Line 400: Private Sub Page_Load(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
MyBase.Load
Line 401: If Not Me.IsPostBack Then
Line 402: SqlDataAdapter1.Fill
(DataSet11, "Employee")
Line 403: lstProducts.DataBind()
Line 404:
Source File: C:\Inetpub\wwwroot\Web9\WebForm1.aspx.vb
Line: 402
Stack Trace:
[SqlException: Login failed for user 'ARTMIC\ASPNET'.]
System.Data.SqlClient.SqlConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen
(IDbConnection connection, ConnectionState& originalState)
System.Data.Common.DbDataAdapter.Fill(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,
String srcTable)
Web9.WebForm1.Page_Load(Object sender, EventArgs e) in
C:\Inetpub\wwwroot\Web9\WebForm1.aspx.vb:402
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
.