"Operation is not allowed when the object is closed" Error



When I try to execute the code below in asp I get the following error
message:

ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.


Rs.Open "SELECT COUNT(KartNo) From Personel WHERE
KartNo="&kayit3&"", Con, 3,3
While Not Rs.Eof
if RS(0) = 0 Then
Set Rs = Con.Execute ("INSERT INTO Personel (Adi, Soyadi, KartNo,
Departman, Unvan) VALUES ('"&kayit1&"', '"&kayit2&"', '"&kayit3&"',
'"&kayit7&"', '"&kayit8&"')")
Else
Rs.Movenext
End If
Wend
Rs.Close

I'll be glad if you help me to solve this problem.

.



Relevant Pages

  • "Operation is not allowed when the object is closed" Error
    ... When I try to execute the code below in asp I get the following error ... Set Rs = Con.Execute ("INSERT INTO Personel (Adi, Soyadi, KartNo, ...
    (microsoft.public.inetserver.asp.db)
  • Re: IIS 5.1 execution questions - application failed to initialize
    ... The identity used by IIS to execute ASP page (and hence your WshShell.Run ... negotiated between the client and IIS in accordance to IIS authentication ...
    (microsoft.public.inetserver.iis)
  • Re: using "Wscript.Shell" in asp
    ... Enable authentication and disable anonymous access to the ASP page ... I want to use the "dtsrun" command in an ASP page. ... When i execute the page, i get no error, but the dtsrun does not seem ...
    (microsoft.public.scripting.wsh)
  • How execute DTS from a ASP
    ... I have found the script that allow to execute the DTS from asp but I have a ... Dim oPkg, oStep, sErr, bSuccess ...
    (microsoft.public.sqlserver.dts)
  • Global Objects
    ... I'm a PHP programmer who has been hired by a company to do web ... I would execute a command something like this: ... // Then I would be able to execute commands something like this: ... in ASP .NET I know there is a Global.asax file that you create ...
    (microsoft.public.dotnet.framework.aspnet)