i get this error now after using the script

Provider error '80040e4d' 

Authentication failed. 

/htdocs/cart/db.asp, line 10 











---------- Original Message ----------------------------------
From: "Tim Morford" <tmorford@n...>
Reply-To: "ASP Databases" <asp_databases@p...>
Date:  Sun, 31 Mar 2002 11:42:25 -0500

>You should close them when you are done with them, if you are not going to
>access the DB on that page anymore.
>
>The way you are opening the Connection Could also be the problem try this
>
>"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
>Server.MapPath("../../db/acart.mdb")
>
>See if that works for you
>
>Tim Morford
>http://www.aspalliance.com/tmorford
>
>-----Original Message-----
>From: danny njuguna [mailto:danny@n...]
>Sent: Sunday, March 31, 2002 5:07 PM
>To: ASP Databases
>Subject: [asp_databases] RE: Too many client tasks
>
>
>the first error is that it points to script bellow , at what point should
>i close the connections cause i close then,
>
>****************************db.asp****************************************
><%
>dim db
>dim strConn
>
>Set db = Server.CreateObject("ADODB.Connection")
>strConn="DRIVER={Microsoft Access Driver (*.mdb)}; "
>strConn=strConn & "DBQ=" & Server.MapPath("../../db/acart.mdb")
>db.Open strConn
>%>
>******************************end db.asp**********************************
>
>here is where i close them on index.asp at the bottom of the page
>
>**************************index.asp***************************************
><!-- #include file="db.asp" -->
>                  |
>                  |
>                  |
>	<%
>		end if
>		db.Close
>		Set db = Nothing
>		%>
>                 |
>                 |
>                 |
>*************************end index.asp**********************************
>
>
>
>
>

--
Danny Njuguna
--

I get this error when i access the product.asp page. This is when i select 
a particular item in the database from 
http://www.gekflies.com/htdocs/cart/category.asp?catcode=1 on the menu on 
the left.


ADODB.Recordset error '800a0cc1' 

Item cannot be found in the collection corresponding to the requested name 
or ordinal. 

/htdocs/cart/product.asp, line 27 



**************************product.asp**************************************
1.<%@ LANGUAGE = "VBScript" %>
2.<!-- #include file="db.asp" -->
3.<!-- #include file="config.asp" -->
4.<!-- #include file="functions.asp" -->
5.<!-- #include file="wishlist.asp" -->
6.
7.<%
8.productid=valid_sql(request.querystring("productid")
9.
10.if productid=null or productid="" or not(isnumeric(productid)) then
11.	response.redirect("error.asp?msg=" & Server.URLEncode("We have no 
record of the product you are looking for."))
12.end if
13.
14.'get the relevant products details
15.set rsprod=db.execute("SELECT * FROM products INNER JOIN categories ON 
16.products.catcode = categories.catcode WHERE productid = " & productid)
17.
18.if rsprod.eof then
19.	response.redirect("error.asp?msg=" & Server.URLEncode("We have no 
record of the product you are looking for."))
20.end if
21.
22.if request.querystring("wish")="add" then
23.	WISHLIST_add(productid)
24.end if
25.
26.'get names and codes of all products in that category
27.set rscatlist=db.execute("select name,productid from products where 
28.catcode=" & rsprod("catcode") & " order by name")
29.%>
**************************************************************************

Thanks alot for your help, it is now working fine http://www.gekflies.com/htdocs/cart/index.asp



--
Danny Njuguna
--