contents.gifindex.gifprev1.gifnext1.gif

3.1 Data Source Names (DSNs)

Once you have successfully installed AcuODBC on your computer, you must create a data source name (DSN) for every group of Vision or relative files that your Windows application needs to access. In order to complete this step, you must choose a directory where "data dictionary" files are stored. These are described in Section 7.1 Data Dictionaries.

The DSN you establish is arbitrary. You should assign a meaningful name that represents the type of data that the files contain, or the type of query that will be made against the files. When users try to access the data files, they will be asked to specify the DSN. How they are asked depends on the application itself.

As discussed in Chapter 2, the data source is one of the main components of an ODBC installation. Physically, data sources consist of sets of data and their associated environments. This means that the term "data source" actually indicates the data files, the operating system, the file system or DBMS used to manage the physical data, and the optional network software used to access this data. The term data source name (DSN), therefore, refers to something rather complicated.

Because part of the ODBC mission is to hide the complexity of underlying software, ODBC architects have chosen to use an abstract name to identify all the components of a data source. This data source name maps all the underlying software components necessary to access the data.

This section describes how to create data source names (or DSNs) for your Vision or relative data files. To create a DSN, you must add the data source name to the ODBC Administrator in the Windows control panel. AcuODBC then automatically modifies the configuration files ODBC.INI and ACUODBC.INI with these parameters.

More:

To add a data source name

To modify data source parameters

To delete a data source name