Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Connecting to a Database » Working with ODBC data sources

Creating an ODBC data source Next Page

Creating ODBC data sources using the ODBC Administrator


On Windows, you can use the Microsoft ODBC Administrator to create and edit data sources. You can work with User Data Sources, File Data Sources, and System Data Sources in this utility.

To create an ODBC data source (ODBC Administrator)
  1. Start the ODBC Administrator by choosing Start > Programs > SQL Anywhere 10 > SQL Anywhere > ODBC Administrator.

    The ODBC Data Source Administrator dialog appears.

  2. Click Add.

    The Create New Data Source wizard appears.

  3. From the list of drivers, choose SQL Anywhere 10, and then click Finish.

    The ODBC Configuration for SQL Anywhere dialog appears.

    The ODBC Configuration for SQL Anywhere dialog where you can specify connection parameters for an ODBC data source.

    For more information about the fields in this dialog, see ODBC Configuration Dialog Help.

  4. When you have specified the parameters you need, click OK to close the dialog and create the data source.

Editing an ODBC data source using the ODBC Administrator

To edit a data source, find and select the desired data source in the ODBC Administrator main window and then click Configure.