Click here to Skip to main content
15,924,507 members
Home / Discussions / Web Development
   

Web Development

 
GeneralJavascript & Textarea Pin
Jonathan Austin31-Jan-03 12:57
Jonathan Austin31-Jan-03 12:57 
GeneralUsing COM inMTS Pin
AnirbanMondal31-Jan-03 1:24
AnirbanMondal31-Jan-03 1:24 
GeneralVBScript runtime err: "Object doesn't support this property or method: 'Form' " Pin
devvvy31-Jan-03 0:02
devvvy31-Jan-03 0:02 
GeneralRe: VBScript runtime err: "Object doesn't support this property or method: 'Form' " Pin
Torsten Mauz31-Jan-03 2:28
Torsten Mauz31-Jan-03 2:28 
GeneralRe: VBScript runtime err: "Object doesn't support this property or method: 'Form' " Pin
devvvy31-Jan-03 9:36
devvvy31-Jan-03 9:36 
GeneralRe: VBScript runtime err: "Object doesn't support this property or method: 'Form' " Pin
devvvy2-Feb-03 20:15
devvvy2-Feb-03 20:15 
GeneralADO recordset error: "Operation is not allowed when the object is closed. " Pin
devvvy30-Jan-03 23:14
devvvy30-Jan-03 23:14 
GeneralRe: ADO recordset error: "Operation is not allowed when the object is closed. " Pin
David Wulff31-Jan-03 4:02
David Wulff31-Jan-03 4:02 
norm wrote:
QUESTION: Is THIS NECESSARY?? What am I doing here exactly? Just closing the recordset? Or recordset PLUS oConn in ONE statement?

You are closing the recordset not the connection. As to whether it is necessary or not, I always do for the sake of keeping everything tidy, but if you are executing a new query ADO will close the recordset for you. I haven't tried, but I suspect closing the connection when you have a recordset open may close the recordset then too, and assigning "Nothing" to it may as well. I would always specifically close the recordset though and not rely on any of that. If nothing else then at least you know when things are open and closed which helps if you are tracking down a problem like this.

As to the "Operation is not allowed when the object is closed" error, do you get an error code, something like -000000000? I haven't checked yet, but there may be different codes for different failed operations. Is the select query returning any records? (I think it should throw a different error if it was, but it's worth checking) Where is the error being thrown? When you open the recordset again or when you call the Find member? If the former, try using oRS = oConn.Execute "sql..." to open your recordset and see if it makes any difference. If not, try creating a new ADODB.RecordSet object. If it still fails, try closing and re-opening the connection too. If an error isn't immeadiately obvious you can usually get a good idea what is triggering it if through trial and error like this.

Also, check you have the latest version of MDAC installed.


GeneralRe: ADO recordset error: "Operation is not allowed when the object is closed. " Pin
devvvy31-Jan-03 9:39
devvvy31-Jan-03 9:39 
GeneralRe: ADO recordset error: "Operation is not allowed when the object is closed. " Pin
David Wulff31-Jan-03 11:39
David Wulff31-Jan-03 11:39 
GeneralRe: ADO recordset error: "Operation is not allowed when the object is closed. " Pin
devvvy31-Jan-03 12:22
devvvy31-Jan-03 12:22 
QuestionMy Newest Website - Testers? Pin
Davy Mitchell30-Jan-03 21:06
Davy Mitchell30-Jan-03 21:06 
QuestionWait( ) function for VBScript? Pin
devvvy30-Jan-03 19:11
devvvy30-Jan-03 19:11 
AnswerRe: Wait( ) function for VBScript? Pin
Torsten Mauz31-Jan-03 2:47
Torsten Mauz31-Jan-03 2:47 
GeneralRe: Wait( ) function for VBScript? Pin
devvvy31-Jan-03 9:42
devvvy31-Jan-03 9:42 
GeneralObject.Sleep Pin
devvvy31-Jan-03 12:25
devvvy31-Jan-03 12:25 
GeneralRe: Object.Sleep Pin
Torsten Mauz31-Jan-03 15:53
Torsten Mauz31-Jan-03 15:53 
GeneralRe: Object.Sleep Pin
devvvy31-Jan-03 17:33
devvvy31-Jan-03 17:33 
GeneralRe: Object.Sleep Pin
Torsten Mauz31-Jan-03 23:39
Torsten Mauz31-Jan-03 23:39 
Generalhere's a simple solution to the problem Pin
devvvy2-Feb-03 20:18
devvvy2-Feb-03 20:18 
Generalscript block and Server.Transfer Pin
devvvy30-Jan-03 17:06
devvvy30-Jan-03 17:06 
GeneralRe: script block and Server.Transfer Pin
devvvy30-Jan-03 17:10
devvvy30-Jan-03 17:10 
GeneralRe: script block and Server.Transfer Pin
Paul Watson30-Jan-03 22:46
sitebuilderPaul Watson30-Jan-03 22:46 
GeneralRe: script block and Server.Transfer Pin
devvvy30-Jan-03 22:47
devvvy30-Jan-03 22:47 
GeneralASP .NET Web Hosting Pin
perlmunger30-Jan-03 6:56
perlmunger30-Jan-03 6:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.