Re: Application Role - aduseclient

From: Gheorghe Popescu (gh_popescu@hotmail.com)
Date: 06/06/02 

From: gh_popescu@hotmail.com (Gheorghe Popescu)
Date: 6 Jun 2002 07:33:00 -0700

I think the explication is that ADO Connection has a default
CursorLocation that is not adUserClient. Therefore, when you set the
CursorLocation after connecting, the existing connection from the pool
cannot be used, since it has different properties, and ADO makes a new
connection that doesn't have the application role activated.

Gheorghe

Relevant Pages

  • Re: Data Provider Could Not Be Initialized
    ... I'm trying to set up a separate ADO connection for a form's recordset. ... Dim cnn As ADODB.Connection ... Dim rst As ADODB.Recordset ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Data Provider Could Not Be Initialized
    ... I'm trying to set up a separate ADO connection for a form's recordset. ... Dim cnn As ADODB.Connection ... Dim rst As ADODB.Recordset ...
    (microsoft.public.access.adp.sqlserver)
  • Data Provider Could Not Be Initialized
    ... I'm trying to set up a separate ADO connection for a form's recordset. ... Dim rst As ADODB.Recordset ...
    (microsoft.public.access.adp.sqlserver)
  • Re: ADO Connection.Execute Method leaves Open SQL Process
    ... Have the App create a single ADODB.Connection object, ... requesting only one connection from a single ADO Connection ... Pool, thus if all requests are sequenced and not over-lapping ...
    (microsoft.public.vb.database.ado)
  • Re: ADO Connection.Execute Method leaves Open SQL Process
    ... your first paragraph where it talks about "a VB6 app". ... requesting only one connection from a single ADO Connection ... ' at this point a new SQL process HAS been created!! ...
    (microsoft.public.vb.database.ado)