Server and Database Names

Use the -n command line switch as a server switch (to name the server). This prevents you from unintentionally connecting to the wrong server.

The server and database names are among the connection parameters that client applications can use when connecting to a database. On Windows, the server name appears on the desktop icon and on the title bar of the server window.

Note: While you can start more than one database, SAP Sybase strongly recommends that you run only one database per IQ server. If you must run multiple databases, start each one on a separate IQ database server, and on a different port.

Default Server Names

If no server name is provided, the first database started provides the default server name.

Case-Sensitivity and Naming Conventions

Server names and database names are case-insensitive on Windows, and case-sensitive on UNIX.

Adopt a set of naming conventions for your servers and databases, as well as for all other database objects, that includes a case specification. Enforcing naming conventions can prevent problems for users.