Requests operation requires a OLE DB Session object

From: Sandra (slino_at_pcrj.rj.gov.br)
Date: 01/22/04 

Date: 22 Jan 2004 12:41:58 -0800

Hi all,

  I am trying to use application roles to access a sql server 2000 in
a web application developed in Delphi with ADO.

  I put in my connection KeepConnection = false, because i want that
every time i need to go to the sql server the connection have to be
restabilished. To that my AfterConnect event of the ADoConnection has
an "exec sp_setapprole", and i am not using the connection poll(my
string connection has the OLE DB Services=-2).

  What else i have to do so i can use application roles in a web
application ?

  Please help me, i donīt know what to do ....

Relevant Pages

  • Re: Sql Server 2000 slow
    ... If I close the connection (moving the Open/Close ... ADO) and the dll gives twice the performance. ... > Are there any known performance issues with .NET accessing Sql Server ...
    (microsoft.public.dotnet.framework.performance)
  • Re: CoInitialize failure with many processes
    ... I could not find a good reference about ADO connection pooling, ... its own connection to the SQL Server. ... Regarding the Performance Monitor, I haven't seen anything out of the ...
    (microsoft.public.win32.programmer.ole)
  • Re: Cross Transactions between ADO & ADO.Net
    ... MARS session pool limited to one connection?). ... > There is one thing that might help here, if you're using SQL Server. ... We even call ADO code from ... >> the DTC cordinator from COM+ to handle the transactions between ADO.Net ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Server extremely slow
    ... my personal experience with a similar setup as your (Sql Server ODBC ... against the sql server (ADO was specifically designed for use with sql ... the connection is closed. ...
    (comp.databases.ms-access)
  • Re: absolute newbie question - connecting to SQL server in ADO.net
    ... How do I get the above connection working? ... > experience of ADO prior to this was in Access 2000. ... Have I wasted my money buying VB.net standard because it can't connect to ... > an SQL server 2000 server? ...
    (microsoft.public.dotnet.framework.adonet)