I am still need a hlep plz :(

[Bob Johnson]

The failure's in your connection somewhere -- thats a valid error message.

What's your exact connection string


"Hamza Al Ali" <hamza.alali@link.net.jo> wrote in message
news:%23VLlZDOXDHA.1816@TK2MSFTNGP09.phx.gbl...

>
> Hi,
>
> I am new at ASP.NET, and I need some help from you.
>
> I am started with a first example got it from MSDN related to the
> Studio.NET, I am going through the example step by step.
>
> The example is easy and simple which is about how to display data from
> database (Pubs) on web page using dataset (SQL Server 7). actually i know
> the username but i do not the password of it, so i created a new login
> (username: "pupuser", password: "pupuser") for the database and i used it
> in the example.
>
> But when i make run for the application I got the following error message:
>
>
> Login failed for user 'pupuser'.
> 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

> 'pupuser'.
>
> Source Error:
>
> Line 3:
> Line 4: Public Sub FillDataSet(ByVal dSet As MyDataSet)
> Line 5: SqlDataAdapter1.Fill(dSet)
> Line 6: End Sub
> Line 7: #Region " Component Designer generated code "
>
>
> Source File: c:\inetpub\wwwroot\MyWebForm\Component1.vb Line: 5
>
> Stack Trace:
>
> [SqlException: Login failed for user 'pupuser'.]
> System.Data.SqlClient.SqlConnection.Open() +761
> System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
> ConnectionState& originalState) +44
> System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord,
> Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
> behavior) +98
> 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
> MyWebForm.Component1.FillDataSet(MyDataSet dSet) in
> c:\inetpub\wwwroot\MyWebForm\Component1.vb:5
> MyWebForm.WebForm1.Page_Load(Object sender, EventArgs e) in
> c:\inetpub\wwwroot\MyWebForm\WebForm1.aspx.vb:33
> System.Web.UI.Control.OnLoad(EventArgs e) +67
> System.Web.UI.Control.LoadRecursive() +29
> System.Web.UI.Page.ProcessRequestMain() +724
>
>
>
>
>
> Best regards.....................
>
>
>
>
>

[Chad Crowder]

Add: ;password=pupuser to your connectionstring just after the packetsize=4096

- Chad
"Hamza Al Ali" <hamza.alali@link.net.jo> wrote in message news:eBaAJWOXDHA.2568@tk2msftngp13.phx.gbl...
Me.SqlConnection1.ConnectionString = "data source=localhost;initial atalog=pubs;persist security info=False; " & _

" user id=pupuser;workstation id=HAMZA;packet size=4096"



"Bob Johnson" <bob2.johnson@ncmail.net> wrote in message news:e5hN6JOXDHA.2256@TK2MSFTNGP10.phx.gbl...

> The failure's in your connection somewhere -- thats a valid error message.
>
> What's your exact connection string
>
>
> "Hamza Al Ali" <hamza.alali@link.net.jo> wrote in message
> news:%23VLlZDOXDHA.1816@TK2MSFTNGP09.phx.gbl...

> >
> > Hi,
> >
> > I am new at ASP.NET, and I need some help from you.
> >
> > I am started with a first example got it from MSDN related to the
> > Studio.NET, I am going through the example step by step.
> >
> > The example is easy and simple which is about how to display data from
> > database (Pubs) on web page using dataset (SQL Server 7). actually i know
> > the username but i do not the password of it, so i created a new login
> > (username: "pupuser", password: "pupuser") for the database and i used it
> > in the example.
> >
> > But when i make run for the application I got the following error message:
> >
> >
> > Login failed for user 'pupuser'.
> > 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

> > 'pupuser'.
> >
> > Source Error:
> >
> > Line 3:
> > Line 4: Public Sub FillDataSet(ByVal dSet As MyDataSet)
> > Line 5: SqlDataAdapter1.Fill(dSet)
> > Line 6: End Sub
> > Line 7: #Region " Component Designer generated code "
> >
> >
> > Source File: c:\inetpub\wwwroot\MyWebForm\Component1.vb Line: 5
> >
> > Stack Trace:
> >
> > [SqlException: Login failed for user 'pupuser'.]
> > System.Data.SqlClient.SqlConnection.Open() +761
> > System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
> > ConnectionState& originalState) +44
> > System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord,
> > Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
> > behavior) +98
> > 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
> > MyWebForm.Component1.FillDataSet(MyDataSet dSet) in
> > c:\inetpub\wwwroot\MyWebForm\Component1.vb:5
> > MyWebForm.WebForm1.Page_Load(Object sender, EventArgs e) in
> > c:\inetpub\wwwroot\MyWebForm\WebForm1.aspx.vb:33
> > System.Web.UI.Control.OnLoad(EventArgs e) +67
> > System.Web.UI.Control.LoadRecursive() +29
> > System.Web.UI.Page.ProcessRequestMain() +724
> >
> >
> >
> >
> >
> > Best regards.....................
> >
> >
> >
> >
> >

>
>