To define Vision parameters and trace file options, press the "Vision options. . ." button when defining data source names in the AcuODBC Setup dialog box. A dialog box displays.
In this box, you can set the Vision file parameters: Max. Files, Max. Locks, Locks Per File, and Buffers. You can also request Vision and SQL trace files for debugging purposes. Complete the fields as instructed below.
Vision Parameters
Max. Files
This parameter equates to the MAX-FILES variable in the runtime configuration file. It sets the maximum number of files that can be opened by AcuODBC. The default is "32". Keeping this value small conserves memory. The highest allowable value of "Max. Files" varies with the operating system.
Max. Locks
This parameter equates to the MAX-LOCKS variable in the runtime configuration file. It sets the maximum number of record locks that can be held by AcuODBC for all of the files together. The default matches the setting of "Max. Files," in this case "32". The maximum value is "8191" for Vision files. Setting this variable to its maximum value can waste resources and is not recommended.
Locks Per File
This parameter equates to the LOCKS-PER-FILE variable in the runtime configuration file. It sets the maximum number of record locks that can be held on a file by a single AcuODBC process. This value affects only the files that are maintaining multiple record locks. The default setting is "10". The maximum value is "8191" for Vision files. Setting this variable to its maximum value can waste resources and is not recommended.
Buffers
This variable equates to the V-BUFFERS variable in the runtime configuration file. It lets you set the number of indexed block buffers to allocate. These buffers are used to improve the performance of indexed files. Each buffer is 512 bytes plus some overhead. Setting this number larger will generally improve file performance. Setting it smaller will save memory. The value can range from "0" (no buffering) to "256". The default is "32".
Debug Options
Vision Trace
This field lets you turn Vision file tracing on and off. Possible values are from "0" to "9"; the higher the number, the more detailed the trace file. A value of "0" or "-1" turns file tracing off. The Vision trace file lists all the Vision file operations attempted by AcuODBC. By default, the trace file is placed in the root directory under the name, "visionn.log" where n is a number that increments each time a log file is created.
SQL Trace
This field lets you turn SQL tracing on and off. Possible values are from "0" to "9"; the higher the number, the more detailed the trace file. A value of "0" or "-1" turns SQL tracing off. The SQL trace file lists all the SQL command operations attempted by AcuODBC. By default, the trace file is placed in the root directory under the name, "acuodbcn.log" where n is a number that increments each time a log file is created.