how do i login to SQL !!!!!

[alonak]

in my asp file there is a conection to sql server

set c=server.createobject("adodb.connection&quot
c.open "dsn="MyDsn";"

i have a problem to login to the sql !!!
how the line is going to add user & password
how do i edit : c.open "dsn="MyDsn";" ?????
thanks a lot .

 

[questhaven]

I would do something like this:
dim connStr, conn

connStr = "Provider=sqloledb;" & _
"Data Source=YourDataSource;" & _
"Initial Catalog=DatabaseName;" & _
"UID=DatabaseLogin;" & _
"PWD=DatabasePassword;"

Set conn = Server.CreateObject("ADODB.Connection&quot
conn.ConnectionString = connStr
conn.open

Then later use:

set rs = conn.execute(yourSQLstatement)