How Connection Parameters Work

When an application connects to a database, it uses a set of connection parameters to define the connection.

Connection parameters include information such as the server name, the database name, and a user ID.

A keyword-value pair, of the form parameter=value, specifies each connection parameter. For example, you specify the password connection parameter for the default password as follows:

Password=sql

Connection parameters are assembled into connection strings. In a connection string, a semicolon separates each connection parameter, as follows:

ServerName=host_iqdemo;DatabaseName=iqdemo

Several connection parameters affect how a server is started. It is recommended that you use the following connection parameters instead of providing the corresponding server options within the StartLine (START) connection parameter:

EngineName (ENG)
DatabaseFile (DBF)
DatabaseName (DBN)

Created May 23, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com