ADODB.Field (0x800A0BCD)

[Fary4u]

Hi

my coding works fine on the net but when i download it to local machine & run the script it's give me this erro ?

Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

here is the coding
[PHP]
Dim strProdName, intPrice
set rsProdInfo = Server.CreateOb ject("ADODB.Rec ordset")
rsProdInfo.Open "products", Conn, adOpenStatic, adLockOptimisti c, adCmdTable

intTotal = 0

rsProd.MoveFirs t
while not rsProd.EOF
rsProdInfo.Move First
rsProdInfo.Find "productID = " & rsProd("product ID")
intProdID = rsProdInfo("pro ductID")
[/PHP]
is any body know's where is the problem is ?

[colinod]

Hi not sure but it looks like it cant find the database

[DrBunchman]

Which line is it erroring on?

Dr B

[Fary4u]

Thanks for the help sorted out