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.

Prerequisites

  • 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/SQLAnywhere12/demo.db.

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

    1. In the Database field, browse to the location of the SQL Anywhere sample database. (For example, /Applications/SQLAnywhere12/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.

Context and remarks

Many.

 Connect to the sample database from Interactive SQL (Mac OS X)
  1. In the Finder, double-click Interactive SQL in /Applications/SQLAnywhere12.

  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.

Results

Interactive SQL starts and connects to the sample database.

Next

None.

 See also