Connect to a database using the Identification, Database, Network, and Advanced tabs on the Connect window.
Field/Button/Option |
Description |
---|---|
Supply user ID and password |
Specifies a user ID and password for the connection. |
User ID |
A user ID for the connection. The default user ID is DBA. The user ID must have permissions to connect to the database. |
Password |
A password for the connection. The default password for the iqdemo database is sql when you connect with the default user, DBA. Passwords are case-sensitive |
Use integrated login |
Connect to the database using an integrated login on Windows. To use this option, the DBA must define an integrated login for you. See System Administration Guide: Volume 1 > Sybase IQ Connections > Integrated Logins. |
None |
Select this option if you are not using an ODBC data source for the connection |
ODBC data source name |
Selects a data source, which is a stored set of connection parameters, for connecting to your database. This field is equivalent to the DSN connection parameter, which references a data source in the registry. You can view a list of data sources by clicking Browse or select a recently used ODBC data source from a list. |
Open the ODBC Data Source Administrator |
Opens the ODBC Administrator window, where you can select an ODBC data source from the list of available data sources. You may also choose to create a new data source or configure an existing data source to use for the connection. |
ODBC data source file |
Selects a data source file for the connection. You can search for the file by clicking Browse or selecting a recently used ODBC data source file from a list. The ODBC data source file is often used for UNIX systems. |
Field/Button/Option |
Details |
---|---|
Server name |
The name of the database server you are connecting to. For remote servers, specify the server as host name:port number. You can choose a recently-used database server name or click Find to search for a server. When you click Find, you see a list of running local personal servers and network servers. Select a database server from the list and click OK. The database server name appears on the Database tab in the Server Name field. |
Start line |
A command to start a personal or a network database server on your computer. Enter a start line only to connect to a local database server that is not currently running and to set your own start parameters. You must enter the full path of the database server. Alternatively, you can choose a recently used start line from the drop-down list. |
Database name |
The name of the database you are connecting to. You need a database name only if there is more than one database running on the database server. If the database is not already running on the server, you should specify the database file instead. You can also select a recently used database, or click Browse to locate the database file. Note:
If you specify both the database name and database file when trying to connect to a database that is already running, the database file is ignored. |
Database file |
Specify the database file when the database you want to connect to is not currently running on a database server. Sybase recommends that you type the full path and name of the database file. 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 drop-down list or click Browse to search for the database file. |
Encryption key |
If the database file is encrypted, you must supply an encryption key to the database server every time the database server starts the database. The Encryption key field is enabled only after you fill in the Database File field. You can also supply encryption options in the Start Line field. |
Start database automatically |
Start the database specified in the Database file field before you connect to it. To ensure that you connect only to a running database, unselect this option. |
Stop database after last disconnect |
Automatically shut down the database after the last user disconnects. |
Field/Button/Option |
Details |
---|---|
Shared Memory |
This protocol is for same-computer communications, and always remains available. It is available on all platforms. |
TCP/IP |
Choose this protocol if you are connecting to a server running on another computer. This protocol is supported on all platforms. |
Host |
The computer name on which the database server is running |
Ping |
Test that a computer with the given host name can be found on your network |
Ports(s) |
The port the database server is using. |
Other |
Any other network protocol options. |
Security |
Choose one of the following: none, simple, or tls. When you choose tls for the Security option, the encryption connection parameters table is enabled. |
certificate_company |
The application only accepts server certificates when the Organization field on the certificate matches this value |
certificate_name |
The application only accepts server certificates when the Common Name field on the certificate matches this value. |
certificate_unit |
The application only accepts server certificates when the Organization Unit field on the certificate matches this value. |
fips |
Choose whether to use FIPS-approved encryption implementations for TLS encryption and end-to-end encryption. |
tls_type |
Specify either ecc or rsa as the encryption cipher to use for synchronization. |
trusted_certificates |
Specify a file containing a list of trusted root certificates used for secure synchronization. |
Connection parameters set in the Advanced tab are superseded by parameters set in the other tabs in the Connect window. For example, if you enter the user ID DBA on the Identification tab, and set the connection parameter “UID=bsmith” on the Advanced tab, Sybase IQ attempts a connection with the user ID DBA.