One more question...



I am doing the first example from Professional ASP.NET and when I try to

select a state from the dropdown I get this error



Exception Details: System.Data.SqlClient.SqlException: Login failed for user

'sa'.



Source Error:



Line 25: 	Dim qry As String

Line 26:

Line 27: 	con.Open()

Line 28:

Line 29: 	qry = "select * from authors where state='" & _





Source File: C:\Inetpub\wwwroot\proasp\SamplePage.aspx    Line: 27





I installed the samples and tutorials as directed in chapter 1.  I see the

pubs databases and there is a user of dbo with a login sa.  I am not sure

what I am doing wrong here.



Any help would be appreciated.



Thanks...



Chad

Hi chad,



My guess is that you have a non-blank password for the "sa" account

(which is probably a good thing!).  You'll need to update the code

sample to include the actual password you've setup for the "sa" account.



Hope this helps,



Scott



-----Original Message-----

From: Chad Angerer [mailto:cangerer@f...]

Sent: Saturday, September 29, 2001 10:19 AM

To: ASP+

Subject: [aspx] [aspx]





One more question...



I am doing the first example from Professional ASP.NET and when I try to

select a state from the dropdown I get this error



Exception Details: System.Data.SqlClient.SqlException: Login failed for

user 'sa'.



Source Error:



Line 25: 	Dim qry As String

Line 26:

Line 27: 	con.Open()

Line 28:

Line 29: 	qry =3D "select * from authors where state=3D'" & _





Source File: C:\Inetpub\wwwroot\proasp\SamplePage.aspx    Line: 27





I installed the samples and tutorials as directed in chapter 1.  I see

the pubs databases and there is a user of dbo with a login sa.  I am not

sure what I am doing wrong here.



Any help would be appreciated.



Thanks...



Chad





---

**Stay Sharp!**



VS.NET will shortly be released. Whether or not you have made the

decision

to move why not make your current development work .Net friendly. Don't

take pot luck. Let the .NET experts take you through these intensive 2 &

3

day hands on courses.



Introduction to VB.NET

Building VB.NET Web Applications ASP.NET

Data Access Using ADO.NET

Building VB.NET Windows Applications

VB.NET Web Services for the Enterprise



For more information or to register email

Peter@v... or visit

http://adtracking.wrox.com/track.asp?x=3DASPnet&url=3Dwww.vbug.co.uk/trai

nin

g

---

You are currently subscribed to aspx as: scottgu@m... To

unsubscribe send a blank email to $subst('Email.Unsub')

Chad,



Sounds to me like you might need to change the connection

string that you are using. Either set the password in the

connection string or use Integrated Security.



	Username & Password Mode:

		"User ID=sa;Password=open sesame;Initial

Catalog=pubs;Server=(local)"



	Integrated Security Mode:

		"Integrated Security=SSPI;Initial

Catalog=pubs;Server=(local)"



If this doesn't get you going, post the code and we will

see what we can do about it.



----------------------------------------

- Mitch Denny

- http://www.warbyte.com

- mitch.denny@w...

- +61 (414) 610-141

-



> -----Original Message-----

> From: Chad Angerer [mailto:cangerer@f...] 

> Sent: Sunday, 30 September 2001 3:19 AM

> To: ASP+

> Subject: [aspx] [aspx]

> 

> 

> One more question...

> 

> I am doing the first example from Professional ASP.NET and 

> when I try to

> select a state from the dropdown I get this error

> 

> Exception Details: System.Data.SqlClient.SqlException: Login 

> failed for user

> 'sa'.

> 

> Source Error:

> 

> Line 25: 	Dim qry As String

> Line 26:

> Line 27: 	con.Open()

> Line 28:

> Line 29: 	qry = "select * from authors where state='" & _

> 

> 

> Source File: C:\Inetpub\wwwroot\proasp\SamplePage.aspx    Line: 27

> 

> 

> I installed the samples and tutorials as directed in chapter 

> 1.  I see the

> pubs databases and there is a user of dbo with a login sa.  I 

> am not sure

> what I am doing wrong here.

> 

> Any help would be appreciated.

> 

> Thanks...

> 

> Chad