configuring SQL and connecting to database

[Ammar]

hi all...
it is me again asking silly questions lol
i am trying to access SQL database through ASP.NET, and i am having some
troubles
i just installed MSDE 2000 and you can safely say that i dont know that much
about configuring the whole thing
here is what i am doing:

<%@ Import Namespace="System.Data.SqlClient" %>

<Script Runat="Server">

Sub Page_Load

Dim condbs As SqlConnection

condbs = New SqlConnection("Server=(local); uid=ammar; database= test")

condbs.Open()

End Sub

</Script>

this is the first step,. just trying to connect to the database, but it
dosent seem to work, i tied reading in the internet but i cant say i became
wiser...

any idea?

 

[Todd Casey]

Have you read this page?
http://msdn.microsoft.com/library/d...ystemdatasqlclientsqlconnectionclasstopic.asp

Does the user "ammar" have a password and if so try adding
"PWD=the_password" to the connection string. Does the "ammar" user exist in
MSDE?

Todd Casey

 

[Ammar]

I tired that but it didnt work
i even used the web data adminstrator to check on the database, but couldnt
do more...
help !!