Set up a data source

SQL Access Manager is an ODBC-compliant application that communicates with any database that supports an available ODBC driver or an OLE DB provider.

You can configure the connection string to the database by several methods:

• Use the Microsoft ODBC Administrator program to configure the ODBC driver for use with SQL Access Manager.

• Run the SQLConnect() function and specify an OLE DB provider with argument values. For more information, see SQL server database applications.

• Set the database connection string with an external UDL file.

Configure an ODBC driver

1. Run the Microsoft ODBC Administrator program.

2. Select a driver or data source, and then select Add New Name, Set Default or Configure. The ODBC Driver Setup dialog box appears.

   Option	Description
   Data Source Name	User-defined name that identifies the data source.
   Description	User-defined description of the data source.
   Database Directory	Identify the folder that contains database files. If none is specified, the current working folder is used.

3. Select OK.

   Note: When you create an ODBC Data Source, an ODBC.INI file is created in the Windows directory. You can manually edit the ODBC.INI file.