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: Need Advice - Access XP and ADO
    ... I changed the ADO connection to point to a database in another directory. ... My ADO Connection component is built to point to the valid and active ...
    (borland.public.delphi.database.ado)
  • Re: Need Advice - Access XP and ADO
    ... Austin ... > I changed the ADO connection to point to a database in another directory. ... > My ADO Connection component is built to point to the valid and active ...
    (borland.public.delphi.database.ado)