Login/Logout (78)

Login/Logout (78)

The Login/Logout operation (B_LOGIN/B_LOGOUT) allows a user to specify his/her user credentials and obtain authentication and authorization tokens from the database engine. This operation also allows the user to reset his/her login credentials so that they must be entered again to gain access to the database.


	Op Code	Pos Block	Data Buf	Data Buf Len	Key Buffer	Key Number
Sent
Returned

•

The database name and the user ID must be pre-defined.

Login Procedure

1

Set the Operation Code to 78.

2

Set the key number to 0.

3

Place the server name, database name, user ID, and password in the key buffer in the form of a database URI. For details about URI connection strings, see Database URIs in Pervasive PSQL Programmer's Guide.

Logout Procedure

1

Set the Operation Code to 78.

2

Set the key number to 1.

3

Place the server name, database name, user ID, and password in the key buffer in the form of a database URI. (In Pervasive PSQL Programmer's Guide, see Database URIs.)

If the Login or Logout operation is successful, the database engine returns status 0; otherwise, one of the following status codes may be returned:


1	Invalid operation
172	Database name not found
3103	Unknown server

The combined length of the database URI must be less than 255 bytes. This is due to the maximum size of the key buffer.

The Login operation has a performance cost. You should not code applications to login and logout on every file. Instead, login once to a database at the beginning of a session, then logout when the database work is complete.

The Login/Logout operation has no effect on any file currency information.