Database Error

<i><b>Originally posted by : Hanoz Elavia (hanozelavia@hotmail.com)</b></i><br />i've created a few database driven asp pages and my connection method is always standard for all pages but one of the pages just doesn't work. it gives the following error<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80040e10' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. <br /><br />/indata/getlists.asp, line 37 <br /><br />my connection code is<br /><br />Dim objConn<br />Dim objRst<br />Dim strSql<br /><br />Set objConn = Server.CreateObject("ADODB.Connection")<br /><br />objConn.Open("DRIVER={Microsoft Access Driver (*.mbd)}; DBQ=C:My Documentsdb_name.mdb")<br /><br />strSql = "Some Select Statement"<br /><br />Set objRst = objConn.Execute(strSql)<br /><br />this code always works all the time, except for one page.<br /><br />please help<br /><br />

<i><b>Originally posted by : M.Krishna Reddy (mckreddy@yahoo.com)</b></i><br />Check your sql statement and field names in the table. This error occurs when the field name you specified in the sqlstatement not present in the table.<br /><br />This error occurs only with Microsoft Access when one of the column names specified in a select statement does not exist in the table being queried. <br /><br />If you use ActiveX Data Objects (ADO) to manipulate data in an Access database from within an Active Server Pages (ASP), and you refer to a column in a table that does not exist then only the error u specified occurs.<br /><br />RESOLUTION<br />Remove any invalid column names from the select statement<br /><br />------------<br />Hanoz Elavia at 7/28/2000 4:56:52 AM<br /><br />i've created a few database driven asp pages and my connection method is always standard for all pages but one of the pages just doesn't work. it gives the following error<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80040e10' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. <br /><br />/indata/getlists.asp, line 37 <br /><br />my connection code is<br /><br />Dim objConn<br />Dim objRst<br />Dim strSql<br /><br />Set objConn = Server.CreateObject("ADODB.Connection")<br /><br />objConn.Open("DRIVER={Microsoft Access Driver (*.mbd)}; DBQ=C:My Documentsdb_name.mdb")<br /><br />strSql = "Some Select Statement"<br /><br />Set objRst = objConn.Execute(strSql)<br /><br />this code always works all the time, except for one page.<br /><br />please help<br /><br />