DtoServices Object

This object is a collection of DtoService objects, representing the Pervasive services running on the server.

Properties


Status	Returns the status of a service. You must pass the service of which you want the status: dtoServiceTransactional dtoServiceRelational dtoServiceIDS
StatusString	Returns the string representation of the current status.

Methods

RestartAllServices method 
StartIDS method 
StartRelational method 
StartTransactional method 
StopIDS method 
StopRelational method 
StopTransactional method

Remarks

The methods of DtoServices control the Pervasive.SQL engine services running on the machine you connected to with the DtoSession object. All these methods return the enumeration DtoResult.

This object lets you start and stop the Pervasive.SQL engine services running on Windows NT or Windows 2000 servers. Also, you can query the current status of Pervasive.SQL services using the Status or StatusString properties.

Security Information Regarding DtoServices Object

This object uses the same user name and password as the DtoSession object to connect to Windows NT or Windows 2000 server.

When using the methods of this object from a web application hosted by Microsoft Internet Information Service (IIS), you must set properties on the directory where the DTO web application resides so that IIS allows DTO to run in the same process as the IIS service. Otherwise, you can obtain the current state of the services, but using the start or stop methods returns DTO error 431 (access denied). To set the IIS folder properties needed for the methods of the DTO Services object, perform the following procedure on folders where DTO web applications are located. Consult your Microsoft IIS documentation for more information on IIS configuration.

To configure IIS to allow starting and stopping of services from a DTO web application

Click Start, select Settings and point to Control Panel.

Double-click Administrative Tools.

Double-click Internet Service Manager.

Browse to the folder containing your DTO ASP application.

Right-click the folder in the left pane and select Properties.

Click the Directory tab.

Specify Low (IIS Process) in the Application Protection field as shown in Figure 3-1.

Figure 3-1 Required IIS Directory Properties for DTO Services Methods

Example

' This example connects to a server and restarts all 
' Pervasive services. 
Dim my_session as new DtoSession 
Dim my_services as DtoServices 
Dim result as DtoResult 
result = my_session.Connect("myserver", "username", 
"password") 
Set my_services = my_session.Services 
result = my_services.RestartAllServices

RestartAllServices method

Stops and then restarts the transactional, relational, and IDS services.

Syntax

result = Services.RestartAllServices

Arguments


Services	DtoServices object

Return Values


result	DtoResult long value indicating the result of the method call. Use the Error property of the DtoSession Object to obtain a description for the result.

StartIDS method

Starts the I*net Data Server service.

Syntax

result = Services.StartIDS

Arguments


Services	DtoServices object

Return Values


result	DtoResult long value indicating the result of the method call. Use the Error property of the DtoSession Object to obtain a description for the result.

StartRelational method

Starts the Relational service.

Syntax

result = Services.StartRelational

Arguments


Services	DtoServices object

Return Values


result	DtoResult long value indicating the result of the method call. Use the Error property of the DtoSession Object to obtain a description for the result.

StartTransactional method

Starts the Btrieve transactional engine service.

Syntax

result = Services.StartTransactional

Arguments


Services	DtoServices object

Return Values


result	DtoResult long value indicating the result of the method call. Use the Error property of the DtoSession Object to obtain a description for the result.

StopIDS method

Stops the I*net Data Server service.

Syntax

result = Services.StopIDS

Arguments


Services	DtoServices object

Return Values


result	DtoResult long value indicating the result of the method call. Use the Error property of the DtoSession Object to obtain a description for the result.

StopRelational method

Stops the Relational engine service.

Syntax

result = Services.StopRelational

Arguments


Services	DtoServices object

Return Values


result	DtoResult long value indicating the result of the method call. Use the Error property of the DtoSession Object to obtain a description for the result.

StopTransactional method

Stops the Btrieve transactional engine service.

Syntax

result = Services.StopTransactional

Arguments


Services	DtoServices object

Return Values


result	DtoResult long value indicating the result of the method call. Use the Error property of the DtoSession Object to obtain a description for the result.