MarVic

ADO Provider

Table of contents:

Introduction. 1

Using provider. 1

Requirements 1

Two files of provider 1

Connecting to provider 1

Other documents: 1

Introduction

This document describes the SecurityLib ADO provider, which is included in SecurityLib package.

The provider uses ActiveX Data Objects and OLE DB interface to access variety of databases. More information about supported database systems you can find in OLE DB documentation.

Using provider

Requirements

The provider needs OLE DB provider and ADO libraries installed on your system. You have to also setup needed aliases and drivers. Also provider uses VCL library. The provider work only with VCL in version 5. It needs following files from Vcl: VCL50.bpl, VCLDB50.bpl and VCLADO50.bpl files. Also, the provider needs the SecurityLib files, that is SecurityLib5.dll and SecurityAdm5.dll.

Two files of provider

The provider is divided onto two parts: the first one, contained in SecurityADO5.dll, supports only reading parameters and rights values. When the User Administrator window or User window is displayed, the SecurityBADOdm5.dll is loaded.

Connecting to provider

The parameters passed to provider during initializing the Security object has following meaning:

· Alias: connection string passed to ADO. For meaning of it refer to ADO documentation.

· DBProvider: This provider is registered as "MarVic:ADO:Vcl5". Depending on the name, the right version of provider is loaded.

· DBEng: only "ADO" value is supported by this provider

· DBPData: The provider accepts null-terminated strings passed as this parameter. In the string there should be options divided by commas. The options may be:

- LocalCursorLocation=0 - Disables ADO local cursor capability. Some of data are maintained on the server and not cached locally. All tables will be in this mode. Default: the option is on.

The example of valid DBPData may be: "LocalCursorLocation=0".