Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

.NET - W2K - ...operation requires an OLE DB Session object...

436300Jan 12 2005
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 9 2005
Added on Jan 12 2005
0 comments
1,303 views