To start a database server and database, and then connect to the local database all from the same computer, you can use the Connect window with the Start and connect to a database on this computer option.
There are no prerequisites for this task.
Open the Connect window in Sybase Central or Interactive SQL.
Complete the following fields to connect to the database:
In the Authentication dropdown list, click Database.
In the User ID field, type a user name. For example, type DBA.
In the Password field, type the password for the user. For example, type sql.
In the Action dropdown list, click Start and connect to a database on this computer.
In the Database file field, specify the database file path, file name, and file extension. For example, type C:\Users\Public\Documents\SQL Anywhere 16\Samples\demo.db;.
To create a database name that is different from the file name for subsequent connections, type a name in the Database name field. Do not specify a file path or extension.
In the Server name field, specify a name for the database server. For example, type demo16.
Since a computer system can run multiple SQL Anywhere database servers, always specify the database server name (ServerName=server-name) when connecting to a database.
Optional: To get a copy of the connection string that is created with this window, click Tools » Copy Connection String to Clipboard.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|