SQL Server (Native Client driver) specific FGLPROFILE parameters

dbi.database.dsname.snc.logintime

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.

dbi.database.dsname.snc.prefetch.rows

Maximum number of rows to be pre-fetched.

dbi.database.stores.snc.prefetch.rows = 50

You can use this parameter to increase performance. However, the bigger this parameter is, the more memory is used by each program.

The default is 10 rows.

dbi.database.dsname.snc.widechar

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).