When connecting to a database, the client application uses a set of connection parameters and connection strings to define the connection.
Connection parameters specify information such as the database server name, the database name, and the user ID.
Each connection parameter specifies a keyword-value pair of the form parameter=value. The following example specifies the password connection parameter PWD:
Connection parameters are assembled into connection strings. In a connection string, a semicolon separates each connection parameter:
Generally, the connection string that is built by an application and passed to the interface library does not correspond directly to the way users enter information. Instead, a user may fill in multiple fields in a connection window, or the application may read connection information from an initialization file.
Many utilities accept a connection string as the -c option and pass the connection string unchanged to the interface library. The following example is a typical Backup utility (dbbackup) command line:
dbbackup -c "HOST=myhost-pc;DBN=mydemo;UID=DBA;PWD=passwd;ServerName=myserver" SQLAnybackup
In your application, you must enter a connection string with the parameter settings separated by semicolons.