select top che non funziona

[Stanislao]

<%
Set Conn1 = Server.CreateObject("ADODB.Connection")
Conn1.Open "driver={MySQL ODBC 3.51 Driver};option=4;server=localhost;user=root;password=pass;DATABASE=db;"
Set rs1 = Server.CreateObject("ADODB.RecordSet")
sql1="Select TOP 8 * forum_topics order by TOPIC_ID desc"
rs1.Open sql1,Conn1,3,3
Do while not rs1.eof 
%>[*]<span>Risposte: <%=rs1("T_REPLIES")%></span>
 <h4><%=rs1("T_SUBJECT")%></h4>
<%=left(rs1("T_MESSAGE"),90) & "..."%>
 " class="read">Leggi Post							

<%
rs1.movenext
Loop
rs1.close
Set rs1=Nothing
Conn1.close
Set Conn1=Nothing
%>

cosa sbaglio ?

ecco l'errore

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/Default.asp, line 121


grazie amici

[Roby_72]

Con MySQL devi usare la LIMIT non la TOP e si mette in coda.

Roby

[Stanislao]

grazie mille mi ero confuso con access