Help! Problem: OLE DB Session error using ASP/vbscript

9 views
Skip to first unread message

Chris White

unread,
Feb 26, 2002, 2:31:45 AM2/26/02
to
Hi
I've just changed some ASP code to use the ADO command object (so that I
could use command parameters) and now have this odd message coming up when
trying to execute a query:
"Requested operation requires an OLE DB Session object, which is not
supported by the current provider."
When the query is first run it returns a recordset - no problem, but if I
retry immediately I get this error. After a minute or so it seems to correct
itself - I've examined/played with timeout options to no avail.

Any suggestions would be appreciated

Chris


Michael Harris (MVP)

unread,
Feb 27, 2002, 12:29:31 AM2/27/02
to
This question would be better posted (and probably answered a *lot* faster) in an ADO newsgroup...

--
Michael Harris
Microsoft.MVP.Scripting
--
"Chris White" <chr...@os-connect.com> wrote in message news:9QGe8.3045$25.1...@newsfeeds.bigpond.com...

Robin Shen

unread,
Feb 27, 2002, 3:18:38 AM2/27/02
to
One possible cause of this error is that the connection your command object
trying to use is created in different processes. We can't use a connection
object with a recordset or command that was created in a separate process
because not all the necessary connection interfaces get marshalled across
process.


Check your code and try to set your web application to run in process in
IIS, hope that helps.


For more information:

Q248287 - INFO: Understanding ADO Marshaling

http://support.microsoft.com/support/kb/articles/q248/2/87.asp

As Michael has suggested, try post to
microsoft.public.ado
microsoft.public.data.ado

Hope it helps.

Regards,
Robin

This posting is provided “AS IS”, with no warranties, and confers no rights.


Reply all
Reply to author
Forward
0 new messages