ASP筆記(連接MYSQL)

先安裝MYSQL ODBC

set conn = server.CreateObject("ADODB.Connection")
conn.open
"DRIVER={};
SERVER = 192.168.X.X;
DATABASE=test;
UID=;
PASSWORD=;
OPTION=3"

str = "SELECT * FROM ..."
set rs = ServerCreateObject("ADODB.recordset")
rs.open str,conn,1,A   A=1(讀) or 3(寫)

rs.Fields.Count
rs(i).Name
rs(i)
rs('column name')
rs.RecordCount
rs.BOF
rs.EOF
rs.MoveFirst
rs.MoveNext
rs.GetRows
rs.Properties.Count
rs.Properties(item).Name
rs.Properties
rs.colse()