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


Connecting to the sample database on Mac OS X

Many of the examples throughout the documentation use the SQL Anywhere sample database. Connect to this database and explore SQL Anywhere.


  • In the Finder, locate the SQL Anywhere sample database and copy the file to a location where you have read and write access. By default, the sample database is located in /Applications/SQLAnywhere16/demo.db.

  • Start a database server. In the Finder, double-click DBLauncher. By default, DBLauncher is located in /Applications/SQLAnywhere16.

    1. In the Database field, browse to the location of the SQL Anywhere sample database. (For example, /Applications/SQLAnywhere16/System/demo.db.)

    2. In the Server name field, type demo.

    3. Click Local Server.

      The Local Server option does not allow client/server communications over a network.

    4. Click Start to start a personal database server named demo.

  1. In the Finder, double-click Interactive SQL in /Applications/SQLAnywhere16.

  2. Connect to the SQL Anywhere sample database by providing the following information in the Connect window:

    • In the Authentication dropdown list, click Database.

    • In the User ID field, type DBA.

    • In the Password field, type sql.

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

    • In the Server name field, type demo.

    • In the Database name field, type demo.

    • Optional: To get a copy of the connection string that is created with this window, click Tools » Copy Connection String to Clipboard.

    • Click Connect.


Interactive SQL starts and connects to the sample database.

 See also