strconnection="driver={mysql odbc 5.1 driver};database=mytest;server=localhost;uid=root;password=password;OPTION=3; Stmt=Set Names "GBK""set mysqlconn = server.createobject("adodb.connection")mysqlconn.open strconnection
strquery = "select * from myuser"set rs = mysqlconn.execute(strquery)m=0if not rs.bof thendo while not rs.eofresponse.write rs("username")&"----"&rs("passwored")&""
rs.movenextloopelseresponse.write("無資料.")end ifrs.closemysqlconn.closeset mysqlconn = nothingset rs = nothing%>
注意版本號，，，
就是那個5.1什麼的。。。
strconnection="driver={mysql odbc 5.1 driver};database=mytest;server=localhost;uid=root;password=password;OPTION=3; Stmt=Set Names "GBK""set mysqlconn = server.createobject("adodb.connection")mysqlconn.open strconnection
strquery = "select * from myuser"set rs = mysqlconn.execute(strquery)m=0if not rs.bof thendo while not rs.eofresponse.write rs("username")&"----"&rs("passwored")&""
rs.movenextloopelseresponse.write("無資料.")end ifrs.closemysqlconn.closeset mysqlconn = nothingset rs = nothing%>
注意版本號，，，
就是那個5.1什麼的。。。