asp连接mysql

<%

strconnection="driver={mysql odbc 3.51 driver};database=weste_net;server=localhost;uid=root;password="

set conn = server.createobject("adodb.connection")

conn.open strconnection



strquery = "select * from News"

set rs = conn.execute(strquery)

if not rs.bof then

%>



<table>

<tr>

<td<b>序列号</b></td>

<td><b>标题</b></td>

</tr>

<%

do while not rs.eof

%>

<tr>

<td><%=rs("id")%></td>

<td><%=rs("NTitle")%></td>

</tr>

<%

rs.movenext

loop

%>

</table>

<%

else

response.write("无暂时没有.")

end if

rs.close

conn.close

set conn = nothing

set rsdata = nothing

%>