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

[Chris White]

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)]

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]

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.