ODBC Options
ODBC
options can be set to determine the behavior of connections through this
data source and to allow some client side debugging. The ODBC Options
dialog has three tabs:
- General
- SQL Statement
- Trace
General
The following settings can be defined in the General section of the ODBC
Options dialog:
Show Splash Window - Display a splash window when a connection
is being established through this data source. Default - Off
Show Downloaded Record Status Window - Display the status
(current row count) of records being downloaded through this data source.
Default - Off
Maximum Download Buffer size - Define the down load buffer
size in K bytes. Default - 64
Interrupt after downloading - Download specified number
of rows then prompt the user to download more or stop download. Default
- Off. Default number - 100
Continue download after waiting n seconds - If interrupt
after downloading is On, will continue with download if user does not
respond to prompt within n seconds. Default - 5 seconds.
Require User Name and Password - Will prompt for user
name and password for each connection. Default - Off
Save User Name and Password - If Require user name and
password is On, will store user name and password in the data source.
Default - Off
SQL
Statement
The following settings can be defined in the SQL Statement section of
the ODBC Options dialog:
Use OMNIDEX SQL Optimization / No OMNIDEX SQL Optimization
- Allow Omnidex to optimize the SQL for maximum performance enhancement.
On Optimization Error - Set behavior when SQL could not
be optimized.
Disallow SQL Statement - SQL statement will fail - default
Resend to Native Database - Pass the SQL to the underlying database.
Prompt for further action - Prompt the user for instructions
Cartesian Retrieval - Set behavior when SQL statement
will result in a cartesian product.
Disallow SQL Statement - SQL statement will fail - default
Allow SQL Statement - SQL results will be a cartesian product
Prompt for further action - Prompt the user for instructions
Show $ROWID column on a detail table - Default - On
Disable Cursor Scrolling in SQLExtendedFetch - Default
- Off
Trim Values on Character Data type Column - Trim leading
and trailing blanks. Default - Off
Trace
The following settings can be defined in the Trace section of the ODBC
Options dialog to enable or disable client side ODBC tracing on this data
source:
Trace Option - Turn tracing on or off
No Trace - Default
Always Trace
Trace Once
Trace Log File - The output filespec that tracing information
will be written to.
Overwrite Trace File - If the output file already exists,
overwrite it. Default - On
Trace Clocks Only - Only write information pertaining
elapsed time for each Omnidex process
Top
|