If present, click to choose a different database type to connect to.
Choose Database and type a user ID and password for the connection. Passwords are case sensitive. See Userid (UID) connection parameter and Password (PWD) connection parameter.
Or choose Windows Integrated Login and connect to the database using an integrated login on Microsoft Windows. When you choose this option, your Windows user ID and password are supplied to the SQL Anywhere integrated login mechanism. See Windows integrated logins.
Use the action Start and connect to a database on this computer when you want to start and connect to a database on the current computer.
When this action is chosen, the following options are available:
Database file Type the full path and name of the database file, for example, C:\sample.db. Otherwise, the path of the file is relative to the working directory of the database server.
You can also choose a recently-used database file from the dropdown list or click Browse to search for the database file. See DatabaseFile (DBF) connection parameter.
Encryption key If the database file is encrypted, you must supply a key to the database server every time the database server starts the database. See DatabaseKey (DBKEY) connection parameter.
Database name Type the name of the database you are connecting to or choose a recently-used database name from the dropdown list. Otherwise, a default name is assigned to the database. This default name is the root of the database file. For example, a database with the file name C:\Database Files\demo.db would be given the default name of demo.
Each database running on a database server is identified by a database name. See Database server names and database names and Connecting to the utility database.
Server name Type the name of the personal server that you are starting. For example, demo. If you are connecting to the default personal server, you can omit the server name.
You can choose a recently-used personal server name from the dropdown list. See Database server names and database names and ServerName (Server) connection parameter.
To start a network server, you must use the Start line field.
Start line Type a command to start a personal or a network database server on your computer. You can also choose a recently used start line from the dropdown list.
Personal database server Enter a start line only if you want to connect to a local database server that is not currently running and if you want to set your own start parameters.
For example to start the personal database server, enter C:\Program Files\SQL Anywhere 16\Bin32\dbeng16.exe -c 8M.
. See StartLine (START) connection parameter.
Network database server Enter a start line to start a network database server on this computer.
For example to start the network database server, enter C:\Program Files\SQL Anywhere 16\Bin32\dbsrv16.exe -x none
. For more information, see StartLine (START) connection parameter.
You can also include options in the Start Line field. Use the Start Line and options when you want to:
Employ any advanced server features.
Control protocol options.
Provide diagnostic or troubleshooting messages.
Set permissions.
Set database parameters (including encryption).
For more information about options you can specify in the Start Line field, see SQL Anywhere database server syntax.
Stop database after last disconnect Select this option to automatically shut down the database after the last user disconnects. See AutoStop (ASTOP) connection parameter.
The following tools are available:
Test Connection This tool tests whether the information provided results in a proper connection. This tool is only available when you are connecting to a SQL Anywhere or SAP Sybase IQ database.
Click Show Details to see debugging information about how the connection parameters are used to find the database server.
Copy Connection String to Clipboard This tool copies the connection string, which is based on the information provided to the clipboard.
Save as ODBC Data Source This tool creates an ODBC data source based on the information provided.
Setup Windows Mobile proxy port This tool helps you set up a TCP/IP port redirector for connecting to Windows Mobile databases (if Windows Mobile services are installed). This tool is only available if you have Microsoft ActiveSync installed and are connecting to a SQL Anywhere or UltraLite database.
If required, you can click Advanced to specify options such as TCP/IP, encryption, and other advanced connection options.
![]() |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |