AcuODBC User's Guide
Version 6.0

XFD Directory

This field specifies the directories that AcuODBC searches for data dictionary (XFD) files. Each Vision or relative file requires a corresponding ".xfd" file. See section 6.2, "XFD Files," for more information on these files.

Tip: For performance reasons, you should keep your data files and ".xfd" files together only if you have few data files to work with. If you have many files, we recommend that split your ".xfd" files between several directories, with each directory containing only the ".xfd" files necessary for a particular DSN or query type. You can then keep the data files together and use the "Data Directory" field to specify the location of the data files.

Enter the full pathname for the directory that contains the XFDs that you want to access:

  1. Enter the name of a directory you want to include in the search path. You can type a path or use the Browse button to locate the directory. Note that if you select the directory using the Browse button, you must click OK. Double-clicking the name of the directory does not insert the name in the entry box.

  2. Note: To ensure accuracy, Acucorp recommends that you use the Browse buttons to specify directories and files. If you enter the file names manually, be careful. AcuODBC does not verify the validity of file names and directories. If you enter an incorrect name, you will not be able to bring the external data into your application.

    The path appears in the entry box of the XFD Directory field.

  3. Click Add. The path to the directory now appears in the lower box in the XFD Directory field.
  4. Repeat these steps for each directory you want to add to the search path. The paths appear in the box in the order in which you enter them.
  5. For optimum performance, list the directories in the order in which you want AcuODBC to search them. To move a directory up in the search order, select that directory and click Move Up. To move a directory down in the search area, select that directory and click Move Down. To delete a directory from the search path, select that directory and click Delete.

You can specify local or remote XFD directories. Note that ".xfd" files residing on the same server as AcuODBC Server are considered local. If you specify a local data dictionary directory, AcuODBC looks for all the ".xfd" files present in this directory, and lets you open the tables that relate to the data dictionaries. You can specify a remote directory only if your files reside on a remote file server and you are using AcuServer.

Storing data dictionary files on the server can help decrease the effort required to maintain these files. That is because modification of data dictionary files on the server directory makes any changes immediately available to all the clients.

To specify a remote directory, use the following syntax:


where server-name is the name of the UNIX or NT server on which the directory containing the data dictionaries resides.

Note: For SQL compatibility, to improve performance, and to ensure that data files and ".xfd" files have the same base name, use underscores, rather than hyphens, in table names. See section 6.2, "XFD Files," for more information.

Note: If the XFD files are on a remote UNIX server and you are accessing them through AcuServer, they must have the lowercase extension ".xfd", regardless of what value you have set in the File Case field on the Advanced tab.

If you are using AcuODBC Server and the remote server is a UNIX server, every alphabetical character in the data dictionary file's name must be lowercase (for example, "accounts.xfd").

You can use both uppercase and lowercase letters for file names on Windows systems (for example, "ACCOUNTS.xfd").

Acucorp, Inc.
Voice: (800) 262-6585 (U.S.A. and Canada)
Voice: (858) 689-4500
Fax: (858) 689-4550

Please share your comments on this manual
or on any Acucorp documentation with the
Acucorp Communications Department.
1988-2003 Acucorp, Inc.
All rights reserved.