I am talking about the connection object var strconn, coz if u don't open the connection object u will get an error 3704 Operation is not allowed when the object is closed.
-----Original Message----- From: Hoenig, Robert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 2:48 PM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Inputting Info to database What do you mean by 1. Make sure u r opening the strconn connection object. I have the Open statement, is that what you are referring to? rsItem.Open strSql, strconn, adOpenKeyset, adLockPessimistic, adCmdTable -----Original Message----- From: Rajput, Goutam [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 1:19 PM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Inputting Info to database 1. Make sure u r opening the strconn connection object. 2. Make sure if u don't have the same recordset object var before u do a createobject on ADODB.Recordset. 3. If you are opening a recordset to update using inline sql statement use adOpenKeyset, adLockOptimistic,adCmdText. Try checking all this points. Thanks -----Original Message----- From: Hoenig, Robert [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 12:20 PM To: [EMAIL PROTECTED] Subject: [wdvltalk] Inputting Info to database I'm trying to input data to a database using a .vbs. I can't get the open string correct. If someone could please look at my code and help me figure out what's wrong. strSql = "Select * From tblproapp_cat where esnum = '" & strES & "' AND revnm = '" & strRevision & "'" set rsItem = CreateObject("ADODB.Recordset") rsItem.Open strSql, strconn, adOpenKeyset, adLockPessimistic, adCmdTable When trying to update the record (and 1 record does exist I checked what it was returning) I get the following error. 3704 Operation is not allowed when the object is closed If I take off , adOpenKeyset, adLockPessimistic, adCmdTable I get the following error. 3251 Object or provider is not capable of performing the requested operation Please help. Thanks Robert ____ * The WDVL Discussion List from WDVL.COM * ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% ____ * The WDVL Discussion List from WDVL.COM * ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% ____ * The WDVL Discussion List from WDVL.COM * ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% ____ • The WDVL Discussion List from WDVL.COM • ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]