ASP ODBC MySQL 사용

<%
set dbcon = Server.CreateObject("ADODB.Connection")
dbcon.Open "Driver={MySQL ODBC 5.1 driver}; Server=localhost; Database="&dbName&"; Uid="&dbId&";Pwd="&dbPasswd&";"
query = "SELECT test_field FROM test_table WHERE where_field = 'xxx' LIMIT"
Set Rs = dbcon.execute(query)
 
While Not Rs.EOF
    test_field = Rs.Fields("test_field")
    Rs.MoveNext
Wend
%>