IBDAC

TIBCConnection.Params Property

Used to specify the connection parameters.

Class

TIBCConnection

Syntax

property Params: TStrings;

Remarks

Use the Params property to specify the connection parameters, such as the username, password, role, and more. For example: user_name=sysdba password=masterkey sql_role_name=role1 lc_ctype=WIN1252

Note that TIBCConnection also has the Username and Password properties, therefore you should use either Username and Password or Params, but not both.

If you are using the Params property to create a new database with the CreateDatabase function, you should set the following parameters: USER 'SYSDBA' PASSWORD 'masterkey' PAGE_SIZE 4096

You can enable compression of data over the wire at global or individual database level by passing WireCompression=True to Params. WireCompression is disabled by default. Note that zlib1.dll should be placed in the same location as fbclient.dll.

Example

Runtime examples:

Params.Add('user_name=sysdba');
Params.Add('password=masterkey');
Params.Add('sql_role_name=role1');
---
Params.Add('USER ''SYSDBA''');
Params.Add('PASSWORD ''masterkey''');
Params.Add('PAGE_SIZE 4096'); 

See Also

© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback