.NET - W2K - ...operation requires an OLE DB Session object...
Getting the following error when running ASP.NET/VB.NET web application on W2K server SP3, MDAC 2.7 SP1, Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573 with Oracle 9.2010:
[COMException (0x800a0e7d): Requested operation requires an OLE DB Session object, which is not supported by the current provider.]
No problems connecting to database with the following connection string:
Provider=OraOLEDB.Oracle;Data Source= ORACLESERVICENM;User ID=user;Password=user;PLSQLRSet=1;
The error happens when attempting to set .ActiveConnection member of ADODB.Command object see below
... With cmdCheckActive
.CommandType = CommandTypeEnum.adCmdStoredProc
.CommandText = "EzCheckActive"
.CommandTimeout = 90
Parm = .CreateParameter("sUsrNm", DataTypeEnum.adVarChar, ParameterDirectionEnum.adParamInput, 50)
.Parameters.Append(Parm)
sMessage = con_open(con, INT_DSN, ADODB.CursorLocationEnum.adUseClient)
If sMessage <> "" Then
CheckActive = False
Exit Function
End If
.ActiveConnection = con
...
End With
What is interesting is that I'm having no problems running the app on my W2K Profession development machine.
Any help would be enormously appreciated.