Visual Basic - Diferencia entre aduseclient y aduseserver!!!!!

Life is soft - evento anual de software empresarial
 
Vista:

Diferencia entre aduseclient y aduseserver!!!!!

Publicado por Dianet (11 intervenciones) el 26/04/2005 07:34:13
Hola que tal, alguien me podría explicar qué diferencia hay entre las propiedades de una conexión en cursorlocation: adUseClient y adUseServer..
Por favor de forma clara y sencilla...
De antemano gracias.. : )
Valora esta pregunta
Me gusta: Está pregunta es útil y esta claraNo me gusta: Está pregunta no esta clara o no es útil
0
Responder

RE:Diferencia entre aduseclient y aduseserver!!!!!

Publicado por Esteban (1144 intervenciones) el 27/04/2005 06:50:32
Clara y sencilla se me hace difícil, pero en el MSDN dice lo siguiente:
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/his/htm/_sna_cursorlocation_property_oledb.asp)

The CursorLocation property on a Connection object or Recordset object indicates the location of the cursor engine. This property sets or returns a Long value representing a CursorLocationEnum.

cursor = connection.CursorLocation
connection.CursorLocation = adUseServer

Remarks

The CursorLocation property is used to set or return the location of the cursor. This property can be set to one of the following CursorLocationEnum constants:

Enumeration Value Description
adUseNone - 1 - This value indicates no cursor location. This value is not supported by the Microsoft® OLE DB Provider for AS/400 and VSAM.
adUseServer - 2 - This value indicates that the data provider or driver-supplied cursor is used.
adUseClient - 3 - This value indicates that a client-side cursor supplied by a local cursor library is to be used.
adUseClientBatch - 3 - For backward compatibility, this value indicates that a client-side cursor supplied by a local cursor library is to be used.

This property setting only affects connections established after the property has been set. Changing the CursorLocation property has no effect on existing connections.

This property is read/write on a Connection object or a closed Recordset, object and read-only on an open Recordset.

If the CursorLocation property is set to adUseClient, the recordset will be accessible as read-only, and recordset updates to the host are not possible. When the CursorLocation property is set to adUseClient (use the client cursor engine), the Find method, Filter property, and Sort property will work if MDAC 2.0 or higher is installed, but will not work properly with earlier versions of ADO.

Valora esta respuesta
Me gusta: Está respuesta es útil y esta claraNo me gusta: Está respuesta no esta clara o no es útil
0
Comentar