Connection strings that I use most often
.net SQL server:
user id=MyLogin;password=MyPass;initial catalog=MyDB;data source=MyServer;Connect Timeout=30
asp SQL server:
provider=sqloledb.1;Server=MyServer;Database=MyDB;UID=MyLogin;PWD=MyPass
example ASP code:
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "provider=sqloledb.1;Server=MyServer;Database=MyDB;UID=MyLogin;PWD=MyPass"
Set rs = conn.execute("SELECT * FROM MyTable;")
do while not rs.EOF
Response.Write "field1: " & rs("field1")
Response.Write "field2: " & rs("field2")
loop