Database problem

[kruxty]

Hi,

i'm having some problems with this code.
When i open the file the page reads for a lot of time and after some time gives error.

Response object, ASP 0104 (0x80070057)
Operation not Allowed
/Checklist/main.asp

I dont understang very well whats happening because i use a similar code in other pages and it works.
Any help?!

This is the code:

Sub verificaperiodo()

Dim adoCon
Dim strSQL
Dim rsperiodo

'Abrir Base de dados e recordset
Set adoCon = Server.CreateObject("ADODB.Connection")

adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("BD\bdchecklist.mdb")
strSQL = "SELECT * FROM chk_vista WHERE periodo=9"
'" & diasemana & " or periodo=9"
Set rsperiodo = Server.CreateObject("ADODB.Recordset")
rsperiodo.Open strSQL, adoCon


Do While Not rsperiodo.EOF
	response.Write("teste")	
Loop

rsperiodo.Close
adocon.close

End Sub

I supose that the problem is in the do while cycle.
Tkx to all help.

K.

 

[DotNetGnat]

make sure that you are closing your recordset and connection objects at the proper places thorughout the code...

-DNG

 

[Sheco]

Is there a missing MoveNext?

 

[Bullschmidt]

And here's a related link:

http://www.aspfaq.com/search.asp?q=80070057&x=10&y=9

Best regards,
J. Paul Schmidt, Freelance Web and Database Developer

http://www.Bullschmidt.com

Access Database Sample, Web Database Sample, ASP Design Tips