%META:TOPICPARENT{name="InstallConfigODBC"}%

==Additional Reading==

=== Create File DSNs=== 

This format of ODBC DSN enables the creation of centralized ODBC DSNs on a designated NT or Windows 95 Server machine, thereby reducing the administrative overhead of ODBC DSN configuration for every single machine within your infrastructure.

The steps for creating an ODBC File DSN are as follows:

1. Select the File DSN Tab from the ODBC Driver Manger. Press the Add button.
      
Figure: 1. File Data Sources %BR% %BR%
<img src="%ATTACHURLPATH%/FILE1.png" style="wikiautogen"/>

2. Pick the ODBC Driver to be used to create your ODBC DSN, in the case of the <nop>OpenLink Universal Data Access Driver Suite 5.0, this would be the Driver identified below as "<nop>OpenLink Generic ODBC Driver".
      
Figure: 2. Data Source Configuration %BR% %BR%
<img src="%ATTACHURLPATH%/FILE2.png" style="wikiautogen"/>
   
3. Enter a name that describes your File DSN (e.g. "Sales by Region" as depicted below) for future use when interacting with it from ODBC compliant application and environments. At present to get full compatability within the Admin Assistant, you must end your dsn name with the extension ".dsn". So for this example the DSN name would be "Sales by Region.dsn".
      
Figure: 3. File Data Sources %BR% %BR%
 <img src="%ATTACHURLPATH%/FILE3.png" style="wikiautogen"/>

4. Verify the displayed paramters are correct, and confirm by hitting Finish button.
      
Figure: 4. File Data Sources %BR% %BR%
<img src="%ATTACHURLPATH%/FILE4.png" style="wikiautogen"/>
   
5. Enter a Description and define the location of the server either by selection, or enter it manually.

      Note the name is not defined here as the filename defines the DSN.
      
Figure: 5. File Data Sources %BR% %BR%
<img src="%ATTACHURLPATH%/FILE5.png" style="wikiautogen"/>
   
6. Complete the fields of the ODBC File DSN. Enter Domain, Database, Server. See above for details of each.

      The File DSN must be verified immediately, so the Login ID and password are required. The Next button will be disabled until login details are provided.
      
Figure: 6. File Data Sources %BR% %BR%
<img src="%ATTACHURLPATH%/FILE6.png" style="wikiautogen"/>
   
7. Complete the fields for additional connection parameters.
      
Figure: 7. Data Source Configuration %BR% %BR%
<img src="%ATTACHURLPATH%/FILE7.png" style="wikiautogen"/>
   
8. This concludes the File DSN generation. The DSN will appear in the list under the File DSN Tab of the ODBC Driver Manger.
      
Figure: 8. File Data Sources %BR% %BR%
<img src="%ATTACHURLPATH%/FILE8.png" style="wikiautogen"/>