The ODBC Data Source Administrator dialog box appears with the User DSN tab selected.
User data source names (DSNs) are one of three types of DSNs managed by the ODBC Data Source Administrator:
| DSN | Description |
|---|---|
| User | Stores information about how to connect to a specific data source; may be used by the current user on the current machine only. |
| System | The most common type of DSN that you and your users will create for Micro Focus XDBC. Same as the User DSN, but available to all users on a particular machine, including NT services. Local to the computer, rather than dedicated to a user. The system, or any user having privileges, can use a data source set up with a system DSN. |
| File | A file-based data source that may be shared among all users who have the same drivers installed. Micro Focus XDBC does not support file DSNs. |
(If Micro Focus XDBC Driver is not an option in the list box, reinstall Micro Focus XDBC on your system.)
The Micro Focus XDBC Setup screen appears. It contains three tabs: General, Advanced, and Logging.
On the General tab, type the information that is requested, then click OK.
| Data Source Name (required) |
Type a string that identifies the name of the data source that you are creating. Specify a name that represents the type of
data in this group of data files or the type of query that will be made against these files. Since this name will be used
every time a user opens this data source, select a name that is meaningful to users. (For example, "ACME Payroll" might be
used for payroll files for the ACME Corporation.)
The name of the data source must be no longer than 63 characters. Follow the Windows file-naming conventions when using special characters in data source names. Also note that the name you choose must be unique. This is a required field. Default value is blank. |
| Description (optional) | Type a description of the data source for additional user clarification. Default value is blank. |
| Network driver | Check this check box if this is a network data source. |
| Hostname | If this is a network data source, type the hostname of the server on which the data resides. |
| Port | If this is a network data source, type the port number on which the server is listening. The default is 20222. |
| Configuration File (required) |
Browse to the configuration file that you created for the data source (a remote file if this is a network data source).
The configuration file defines the location of your indexed files, file case instructions, and much more. This is a required field. It must be located in the installation directory and is named mfdbc.cfg by default. For more information on this file, see the chapter Configuration. |
| Username (optional) | A username for the person who will be logging into the database on this machine. Default value is blank. If you have set up usernames, but the Username field is blank, you will be prompted for one at the time of connect. |
| Password (optional) |
A password to be associated with the username. Default value is blank. If you have set up passwords, but the
Password field is blank, you will be prompted for one at the time of connect.
For information on alternative measures of data security, see the sectionGranting Database Privileges. |
| Confirm Password | Confirm the password by typing it a second time. |
On the Advanced tab, type the information that is requested, then click OK.
| Fetch Buffer Size | Specify the size of the fetch buffer in bytes. The fetch buffer indicates how much data will be fetched or retrieved from a query at a time. Allowable values are 1024 through 32766. Default value is 4096. |
| Merge Buffer Size | Specify the size of the merge buffer in rows. This is the number of unique rows that your query can return. Default value is 10,000. |
| Memory Sort Pages | Specify the number of memory sort pages. This indicates how many of the Total Sort Pages will reside in memory. Allowed values are 100 to 999,999. Default value is 1000. |
| Total Sort Pages | Specify the total number of sort pages. Total sort pages is the number of virtual memory pages used to sort results sets. Allowed values are 1000 to 99,999,999. Default value is 10,000. |
| Maximum Statements | Specify the maximum number of statements allowed. Values are 10 to 4096. Default value is 256. (See Maximum Cursors.) |
| Maximum Cursors |
Specify the maximum number of cursors allowed. Allowable values are
10 to
1024. Default value is
64.
Micro Focus XDBC has a concept of logical cursors (nlc) that are mapped over a smaller number of actual DB Cursors (ndc). If you create fewer SQL statements equal to or fewer than the number of DB Cursors set, it's a straight one-to-one relationship. However, when you attempt to open more cursors, Micro Focus XDBC searches for the oldest soft-closed logical cursor that it canunhook from a database cursor and assign to the new statement. If the application tries to use the original statement, Micro Focus XDBC will look for another unused logical cursor to donate its DB Cursor. If no cursors can be unhooked (because results are pending), an error message Too many concurrently open cursors is returned. |
| Maximum Columns |
Specify the maximum number of columns allowed in a single table. Allowable is
1 to
1024. Default value is
256. (Note that some Microsoft applications will not allow more than 256 columns in a table.)
Note: The indexed file or table supports 65535 field names (columns); however, you may be limited in your queries to the table
based on the query tool used. For instance, the command-line query tool will support only result sets with a maximum number
of 512 columns. Queries through ODBC Driver default to 1024 columns.
|
You can gather information from Micro Focus XDBC to help you troubleshoot server processes and debug your client applications. On the Logging tab, type the information that is requested or accept the defaults, then click OK.
| Log Filename | Browse to the name of the local log file used for Micro Focus XDBC logging. Log files are created in the local directory that is current when Micro Focus XDBC starts. If you want your log file to write to another location, you must specify a fully-qualified file name. |
| Full Logging | Check this check box if you want detailed logging on the client. By default, Micro Focus XDBC performs abridged logging. Abridged logging, more space-efficient, records only selected items rather than the complete control structure. |
| SQL Logging | Check this check box if you want to create an SQL log file locally. |
| Include Time | Check this check box if you want to include the time to complete each call in the local log file. |
| Unique Filenames | Check this check box if you want unique identifiers to be appended to the name of the local log file. |
These options appear when you check the Network driver checkbox on the General tab:
| Log Filename | Browse to the name of the remote log file used for Micro Focus XDBC logging. By default, this is ACUXDBC_HOST_LOGFILE_pid.log, where pid is the host process ID. Log files are created in the local directory that is current when Micro Focus XDBC starts. If you want your log file to write to another location, you must specify a fully-qualified file name. |
| Full Logging | Check this check box if you want detailed logging on the host. By default, Micro Focus XDBC performs abridged logging. Abridged logging, more space-efficient, records only selected items rather than the complete control structure. |
| SQL Logging | Check this check box if you want to create an SQL log file on the host. |
| Include Time | Check this check box if you want to include the time to complete each call in the log file on the host. |
| Unique Filenames | Check this check box if you want unique identifiers to be appended to the name of the remote log file. |