Where is oConn defined? I fixing to do the same exact thing and do
recall needing to change the connection. Is it looking at the new
server hostname in the connection statement? Does anything work
or this is the first thing you noticed didn't work?
Originally posted by warrenb
I wonder if someone can help me.
I designed a web-site using asp pages that access an SQL DB. Thing work fine, but I moved the web-site to another server and now I get the following error: -
"Requested operation requires an OLE DB Session object, which is not supported by the current provider."
I file that has the problem is here: -
function dbNewCommand( oConn, procedureName )
set objCommand = server.CreateObject( "ADODB.Command" )
set objCommand.ActiveConnection = oConn
objCommand.CommandText = procedureName
set dbNewCommand = objCommand
I must stress that this file works, unaltered, on the other web server.