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="Syst em.Data.SqlClie nt" %>

<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/de...classtopic.asp

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

Todd Casey
"Ammar" <am**********@c omhem.se> wrote in message
news:RJ******** **********@news b.telia.net...

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="Syst em.Data.SqlClie nt" %>

<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?

[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 !!
"Todd Casey" <todd@_SPAMMER_ GET_A_LIFE_velo citywest.com> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..

Have you read this page?
http://msdn.microsoft.com/library/de...classtopic.asp
Does the user "ammar" have a password and if so try adding
"PWD=the_passwo rd" to the connection string. Does the "ammar" user exist in MSDE?

Todd Casey
"Ammar" <am**********@c omhem.se> wrote in message
news:RJ******** **********@news b.telia.net...

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="Syst em.Data.SqlClie nt" %>

<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?