|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET 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? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
