Hi everyone, I'm new here.
My problem: the parameters that appear after rs.open when oppening the SQL connection.
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/misc/page.asp, line 135
Code
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("prot/data.mdb")
sql= "SELECT Gallery, Name, Comments, Date FROM tblComments WHERE Gallery = " & fname
rs.Open sql, Conn
Do While Not rs.eof
Response.Write "<table cellspacing=0 cellpadding=5 width=""100%""><tr>"
Response.Write "<td bgcolor=#EFEFEF><font face=arial size=2 color=#093173><b>" & rs("Name") & "</td>"
Response.Write "<td bgcolor=#EFEFEF><font face=arial size=2 color=#000000>(" & rs("Date") & ")</td>"
Response.Write "</tr><tr>"
Response.Write "<td colspan=2>" & rs("Comments") & "</td>"
Response.Write "</tr></table>"
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
Set Conn = Nothing
%>
Line 135 is "rs.Open sql, Conn, 3,3"
On a different page I had this problem but then changed the parameters to "rs.Open sql, Conn, 1,3,1" and it worked fine.
Appreciate any help.