| Database connections / Database vendor specific parameters in FGLPROFILE | |
Connection timeout (in seconds).
dbi.database.stores.snc.logintime = 5
Set this parameter to raise an SQL error if the connection can not be established after the given number of seconds.
The default is 5 seconds.
Maximum number of rows to be pre-fetched.
dbi.database.stores.snc.prefetch.rows = 50
Use this parameter to increase performance by defining the maximum number of rows to be fetched into the db client buffer. However, the bigger this parameter is, the more memory is used by each program.
The default is 10 rows.
Control wide char usage for character string data.
Set this parameter to false if you use char/varchar columns in the SQL Server database.
dbi.database.stores.snc.widechar = false
By default the SNC driver uses wide char ODBC functions, by converting the character data from the current locale to UCS/2, by adding the N prefix before string literals and by binding SQL parameters with SQL_C_WCHAR and SQL_WCHAR/SQL_WVARCHAR types.
If you set this parameter to false, the driver will pass the character strings as is without character set conversion, leave the string literals without N prefix and bind character string parameters with SQL_C_CHAR and SQL_CHAR/SQL_VARCHAR.
The default is true (use wide chars).