my goal is that I want to use the content of #tmp1. When I try to
access it with a recordset, i get the error 3709 :
Unable to use this connection to do this operation. It is closed or
not valid in this context.
That's the purpose of my question.
Well why don't you show us the code that leads to this error?
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Re: Query-based update failed because the row to update could not be found ... > pessimistic locking in ASP applications. ... >> Dim Conn, connection, rsProd ... > eliminate these lines (no recordset is needed): ... > quicker response by posting to the newsgroup.... (microsoft.public.inetserver.asp.db)
Re: VB.NET ADO Recordset DataGridView and Access not in sync w/oth ... I had it mostly written in ADO.NET BEFORE I decided Recordset... certain conditions it will change a field in the database.... a classic COM ADODB connection and recordset via Interop, ... but this is a classic ADO newsgroup.... (microsoft.public.data.ado)
Re: ADO recordset doesnt see DB changes ... Just wanted to let you know that by executing a Resyncof recordset 2, ... The way my app is set up there is only 1 connection path to ... the DB (that is I only open the database once) which both recordsets ... Please reply to the newsgroup.... (microsoft.public.data.ado)
RE: VBscript Error on SBS2k3 ... double confirm if your router and client computer does not have incoming ... This newsgroup only focuses on SBS technical issues. ... | Accessories and Communications and Remote Desktop Connection?... | computer and your router does not have incoming TCP port 4125 opened. ... (microsoft.public.windows.server.sbs)