Hi..When I try to open a page with the code below, the page times out. When I run the same query using phpmyadmin, everything works fine. I can't seem to figure out what the problem is.
<%
Dim conn, rs, query
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={MySQL ODBC 3.51 Driver}; Server=*****; Database=todo; UID=*****; PWD=****"
query = "SELECT * FROM todo where priority='high'"
Set rs = conn.Execute(query)
While Not rs.EOF
Response.Write "<tr><td><input type='radio' name='radiobutton' value='radiobutton'></td>" & _
"<td>" & rs("AddDate") & "</td><td>" & rs("Description") & "</td><td>" & _
"<td>" & rs("Priority") & "</td><td>more info</td></tr>"
Wend
conn.Close
rs.Close
Set conn = nothing
Set rs = nothing
%>