Using AcuODBC's multi-company support option, you can manage customer data files from several companies with a single DSN. The data files from each customer (company) are structured the same and even named the same, but stored in a different directory.
The name of the company directories can assume several formats. Usually the name is composed of two different parts: a fixed prefix (or suffix), like acct for example, and a variable that is used to identify the company itself. This variable can be a progressive digit or a part of the name of the company. The directory name can also reflect the name of the company itself, barring operating system naming restrictions.
For instance, you may have accounting records for 100 different companies to maintain. The first three companies on the list are ABC Corporation, Acme Glass Company, and Acucorp, Inc. Each company has its own directory for accounting records on @server1, and the directories are named acctxxx, where where xxx is an abbreviation of the company name (acctabc, acctacme, acctacu . . .). The data files in these directories are named data001, data002, and so on, with corresponding .XFD files, and for Vision Version 4 , .VIX files.
@server1:/acctabc/ data001.dat data001.vix data001.xfd data002.dat data002.vix data002.xfd DSN: ABC Corporation Data Dictionary Directory: /acctabc @server1:/acctacme/ data001.dat data001.vix data001.xfd data002.dat data002.vix data002.xfd DSN: Acme Glass Data Dictionary Directory: /acctacme
If you organize your customer files this way, you can use the multi-company option to maintain the files with a single, master DSN. This way, if you relocate your files to another server node, you have only to change the DSN file prefix specification for the master file, and all of your customer files will follow suit.