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/SQLAnywhere16/demo.db;.
Start a database server. In the Finder, double-click DBLauncher. By default, DBLauncher is located in /Applications/SQLAnywhere16.
In the Database field, browse to the location of the SQL Anywhere sample database. (For example, /Applications/SQLAnywhere16/System/demo.db;.)
In the Server name field, type demo.
Click Local Server.
The Local Server option does not allow client/server communications over a network.
Click Start to start a personal database server named demo.
TaskIn the Finder, double-click Interactive SQL in /Applications/SQLAnywhere16.
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.
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |