Connection error

<i><b>Originally posted by : Doug Seven (doug.seven@codejunkies.net)</b></i><br /><br />Generally this means there is probably a typo in the SQL Statement. Basically, your data provider can not find one of the columns or tables you specified. My experience (I teach this stuff, and students get this all the time) is that this is the result of a mistyped SQL Statement. One thing you can do is build the SQL Statement in Access Query Designer, then view it in SQL, and copy/paste it to your ASP code.<br /><br />Doug Seven<br />CodeJunkies.Net / ASPNextGen.com<br />doug.seven@codejunkies.net<br /><br />------------<br />Frank at 9/1/2000 5:31:51 AM<br /><br />Trying to build a storefront connected to an Access database and repeatedly getting this 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 />/disser/CatList.asp, line 7 <br /><br />Can anybody please help?????<br /><br />

<i><b>Originally posted by : Frank (Francislowry@hotmail.com)</b></i><br />Trying to build a storefront connected to an Access database and repeatedly getting this 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 />/disser/CatList.asp, line 7 <br /><br />Can anybody please help?????<br /><br />