|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Which Object is Closed (Error 3704) |
|
From: |
Leslie |
|
Date: |
10/26/1999 4:38:08 PM |
|
IP: |
204.108.8.1 |
How does one determine which application object an ASP pages thinks is closed? I thought I had a connection & recordset open, but I keep getting this error message: "3704: The operation requested by the application is not allowed if the object is closed."
I was trying to update some data with this code:
Dim Connect, RecSet, Query
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "DBQ=" & Server.MapPath("dbLessons.mdb") & ";Driver={Microsoft Access Driver
(*.mdb)};DriverId=25;MaxBufferSize=8192;Threads=20;", "username", "password"
Set RecSet = Server.CreateObject("ADODB.Recordset")
Query = "SELECT * FROM LessonId WHERE LessonId=" & Request("LessonId")
RecSet.Open Query, Connect, adOpenDynamic, adLockOptimistic
RecSet("Keywords") = Request("Keywords")
RecSet("Posted") = Date
RecSet.Update
These connection & recordsets work fine when I use them for adding or searching records.
Any clues? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
