
20751-12 Rev.5 5-7
Installing and Configuring ODBC for Windows
The Advanced Options tab shows more options, as shown in Figure 5-5.
Figure 5-5: System DSN Advanced Configuration Options.
You can change these or accept the default options.
Read Only — A boolean value that controls whether the database allows read-only
access (only SQL Select statements are allowed), or full access. The default is
deselected, which allows full access. To modify data, do not select the checkbox. If
you do, only SQL Select statements are allowed.
Show System Tables — When retrieving a list of tables, this boolean value controls
whether the system tables are included in the list. The default is deselected to
omit system tables.
Legacy SQL Tables Behavior — A boolean value that, when enabled, causes SQLTa-
bles to return a list of all the users that own a database. The default is deselected
to omit the list of users.
Treat Numeric as Char — When selected, this boolean value causes the driver to
treat SQL_C_NUMERIC buffers as SQL_C_CHAR buffers. By default, this is dese-
lected, which means that SQL_C_NUMERIC are treated as Numeric Structures.
Return SQL_BIT as 1/0 — If enabled, when a return type is char or wchar, this
boolean value returns the values 1 or 0 instead of t or f. The default is deselected
to return t/f values. If you prefer that SQL_BIT return numeric boolean values (1/
0), select the checkbox.
Strip CR/LF — If enabled, this removes the carriage return and line feed characters
from the SQL statements. The default is deselected to not remove these charac-
ters. Selecting the checkbox strips control characters out of your data.
Load Round Fraction — If the value is true, it rounds the actual data for numeric
columns whose precision exceeds the precision defined in the target table. The
default is deselected, to not round.
Login Timeout — The number of seconds after which to terminate the login pro-
cess. Valid values are 0 (no timeout) or any positive number.
Query Timeout — The number of seconds after which to terminate the query
request. Valid values are 0 (no timeout) or any positive number.
Comentários a estes Manuais