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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » Database connections » ODBC data sources

 

Creating an ODBC data source (administration tools)

To quickly create an ODBC data source, use the Connect window in the administration tools.

Prerequisites

A database is running on the local computer.

 Task
  1. Open the Connect window.

  2. If using Interactive SQL and if required, click Change database type, and then click SQL Anywhere.

  3. Enter a User ID.

  4. In the Action dropdown list, click Connect to a running database on this computer to connect to a database that is running on your computer.

  5. If desired, specify a Server name.

  6. If desired, specify a Database name.

  7. Click Tools » Save As ODBC Data Source.

  8. In the Enter the name for this new data source field, type a name for the data source.

  9. In the Select the data source type list, specify whether the data source is available only for the current user or all users (including Windows services).

  10. (Optional) Click Save the user ID and password in the data source.

    Caution

    Storing user IDs, encrypted or unencrypted passwords, and database keys in a data source is not recommended.

  11. (Optional) If you are running the 64-bit version of the administration tools and you also have the 32-bit ODBC driver installed, then you have the option to click Create both 32 and 64-Bit data sources.

    • If you are creating a system data source, then select this option to create two system data sources: one data source that can be used by 32-bit applications and one data source that can be used by 64-bit applications.

    • If you are creating a user data source, this option is ignored.

  12. Click Save and respond to the prompts to create the data source or sources.

Results

The ODBC data source is created.

 See also