ASP database connection

Common ASP database connection methods and techniques

<%
Sqlstr = "driver = {SQL Server}; server =.; uid = sa; Password = 123456; database = mjdb"
Set sqlcon = server. Createobject ("ADODB. Connection ")
Set myrs = server. Createobject ("ADODB. recordset ")
MySQL = "select * From macinfo"
Sqlcon. Open sqlstr
Myrs. Open MySQL, sqlcon, 1, 3
Do while not myrs. EOF
Response. Write myrs ("remark") & "<br/>"
Myrs. movenext
Loop
Myrs. Close
Sqlcon. Close

%>
// Method 1:
Mm_conn_string =
"Driver = {SQL Server}; server =.; uid = sa; Password =; database = KK ;"
Set conn = server. Createobject ("ADODB. Connection ")
Conn. Open mm_conn_string
Set rs = server. Createobject ("adobd. recordset ")
SQL = "select * from Table order by ID DESC"
Rs. Open SQL, Conn, 3, 3

// Method 2: (DSN connection)

Mm_conn_string = "DSN = BBS; uid = sa; Pwd = 12345"
Set conn = server. Createobject ("ADODB. Connection ")
Conn. Open mm_conn_string
Set rs = server. Createobject ("adobd. recordset ")
SQL = "select * from Table order by ID DESC"
Rs. Open SQL, Conn, 3, 3 // 3, 3 is to modify, delete, add switch!

// Method 3:

Mm_conn_string_own = "driver = {SQL}; server = (local); uid = sa; Pwd = 11111; database = infs ;"
Set conn = server. Createobject ("ADODB. Connection ")
Conn. Open mm_conn_string_own

// Method 4-this method is used in access
strconn = "driver = Microsoft Access Driver (*. MDB); DBQ = "_
& server. mappath ("ASP. mdb ")
set conn = server. createobject ("ADODB. connection ")
Conn. open strconn