IBX.IBDatabase.TIBDatabase.Params
Delphi
property Params: TStrings read FDBParams write SetDBParams;
C++
__property System::Classes::TStrings* Params = {read=FDBParams, write=SetDBParams};
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | published | IBX.IBDatabase.pas IBX.IBDatabase.hpp |
IBX.IBDatabase | TIBDatabase |
Description
Specifies the database parameters to pass to the InterBase server.
Use Params to specify the database parameters to pass to the InterBase server as a list of name-value pairs. TIBDatabase passes database parameters to the server as text in order to establish the connection.
For example:
IBDatabaseInstance.Params.Clear; // Clear any previously-set parameter.
IBDatabaseInstance.Params.Add('user_name=SYSDBA');
IBDatabaseInstance.Params.Add('password=masterkey');
IBDatabaseInstance.Params.Add('sql_role_name=finance');
IBDatabaseInstance.Params.Add('lc_ctype=WIN1252');
The following table lists all supported parameter names. IBDatabase Parameter is the string that you must use in Params. InterBase API Parameter is the DPB parameter, the actual parameter of the InterBase API. For detailed information about each parameter, look up the DPB parameter entry in the InterBase API Guide, DPB Parameters.
| IBDatabase Parameter | InterBase API Parameter |
|---|---|
activate_shadow
|
isc_dpb_activate_shadow
|
admin_option
|
isc_dpb_admin_option
|
allocation
|
isc_dpb_allocation
|
archive_database
|
isc_dpb_archive_database
|
archive_dumps
|
isc_dpb_archive_dumps
|
archive_journals
|
isc_dpb_archive_journals
|
archive_recover
|
isc_dpb_archive_recover
|
archive_sweep
|
isc_dpb_archive_sweep
|
begin_log
|
isc_dpb_begin_log
|
buffer_length
|
isc_dpb_buffer_length
|
cache_manager
|
isc_dpb_cache_manager
|
cdd_pathname
|
isc_dpb_cdd_pathname
|
client_interbase_var
|
isc_dpb_client_interbase_var
|
connect_timeout
|
isc_dpb_connect_timeout
|
damaged
|
isc_dpb_damaged
|
dbkey_scope
|
isc_dpb_dbkey_scope
|
debug
|
isc_dpb_debug
|
delete_shadow
|
isc_dpb_delete_shadow
|
disable_journal
|
isc_dpb_disable_journal
|
disable_wal
|
isc_dpb_disable_wal
|
drop_walfile
|
isc_dpb_drop_walfile
|
dummy_packet_interval
|
isc_dpb_dummy_packet_interval
|
enable_journal
|
isc_dpb_enable_journal
|
encrypt_key
|
isc_dpb_encrypt_key
|
flush_interval
|
isc_dpb_flush_interval
|
force
|
isc_dpb_force
|
force_write
|
isc_dpb_force_write
|
garbage_collect
|
isc_dpb_garbage_collect
|
gbak_attach
|
isc_dpb_gbak_attach
|
gbak_ods_minor_version
|
isc_dpb_gbak_ods_minor_version
|
gbak_ods_version
|
isc_dpb_gbak_ods_version
|
gbak_validate
|
isc_dpb_gbak_validate
|
gfix_attach
|
isc_dpb_gfix_attach
|
gstat_attach
|
isc_dpb_gstat_attach
|
instance_name
|
isc_dpb_instance_name
|
interp
|
isc_dpb_interp
|
journal
|
isc_dpb_journal
|
lc_ctype
|
isc_dpb_lc_ctype
|
lc_messages
|
isc_dpb_lc_messages
|
license
|
isc_dpb_license
|
no_garbage_collect
|
isc_dpb_no_garbage_collect
|
no_reserve
|
isc_dpb_no_reserve
|
num_buffers
|
isc_dpb_num_buffers
|
number_of_users
|
isc_dpb_number_of_users
|
old_dump_id
|
isc_dpb_old_dump_id
|
old_file_name
|
isc_dpb_old_file_name
|
old_file_size
|
isc_dpb_old_file_size
|
old_num_files
|
isc_dpb_old_num_files
|
old_overwrite
|
isc_dpb_old_overwrite
|
old_start_file
|
isc_dpb_old_start_file
|
old_start_page
|
isc_dpb_old_start_page
|
old_start_seqno
|
isc_dpb_old_start_seqno
|
online
|
isc_dpb_online
|
online_dump
|
isc_dpb_online_dump
|
overwrite
|
isc_dpb_overwrite
|
page_size
|
isc_dpb_page_size
|
password
|
isc_dpb_password
|
password_enc
|
isc_dpb_password_enc
|
preallocate
|
isc_dpb_preallocate
|
quit_log
|
isc_dpb_quit_log
|
recover_until
|
isc_dpb_recover_until
|
reserved
|
isc_dpb_reserved
|
sec_attach
|
isc_dpb_sec_attach
|
set_db_readonly
|
isc_dpb_set_db_readonly
|
set_db_sql_dialect
|
isc_dpb_set_db_sql_dialect
|
set_group_commit
|
isc_dpb_set_group_commit
|
set_page_buffers
|
isc_dpb_set_page_buffers
|
shutdown
|
isc_dpb_shutdown
|
shutdown_delay
|
isc_dpb_shutdown_delay
|
sql_dialect
|
isc_dpb_sql_dialect
|
sql_role_name
|
isc_dpb_sql_role_name
|
sweep
|
isc_dpb_sweep
|
sweep_interval
|
isc_dpb_sweep_interval
|
sys_encrypt_password
|
isc_dpb_sys_encrypt_password
|
sys_user_name
|
isc_dpb_sys_user_name
|
sys_user_name_enc
|
isc_dpb_sys_user_name_enc
|
trace
|
isc_dpb_trace
|
user_name
|
isc_dpb_user_name
|
verify
|
isc_dpb_verify
|
wal_backup_dir
|
isc_dpb_wal_backup_dir
|
wal_bufsize
|
isc_dpb_wal_bufsize
|
wal_chkptlen
|
isc_dpb_wal_chkptlen
|
wal_grp_cmt_wait
|
isc_dpb_wal_grp_cmt_wait
|
wal_numbufs
|
isc_dpb_wal_numbufs
|
working_directory
|
isc_dpb_working_directory
|