MS SQL Database Connection String

Using DSN

<%
 
'Your connection here
set conn = server.createobject("ADODB.Connection")
conn.open "DSN=your-dsn; UID=sqldbuser; PWD=sqldbpass"
set rs = server.createobject("ADODB.recordset")

%>

Standard Security

Driver={SQL Native Client};Server=SQL-Server-Address;Database=your-sql-db;Uid=sqldbuser;Pwd=sqldbpass;