This string includes the options used to connect with basic user ID and password authentication.
Note: The strings demonstrated in this section use the DSN-less format. For additional formats, see "Using a connection string". 
DRIVER=DataDirect 8.0 Informix Wire Protocol;HostName=host_name;PortNumber=port_number;
ServerName=server_name;Database=database_name;LogonID=user_name;Password=password;
[attribute=value[;...]];

where:

host_name

specifies the IP address or the host name of the computer that is running the database server to which you want to connect.

port_number

specifies the port number of the server listener.

server_name

specifies the name of the database server to which you want to connect.

database_name

specifies the name of the database to which you want to connect.

user_name

specifies your username.

password

specifies your password.

attribute=value

specifies connection option settings. Multiple connection option attributes are separated by a semi-colon.

Note: The LogonID and Password options are not required to be stored in the connection string. They can also be sent separately by the application using the SQLConnect ODBC API. For SQLDriverConnect and SQLBrowseConnect, they will need to be specified in the connection string.

The following example connection string includes the options for connecting with the user ID/password authentication.

DRIVER=DataDirect 8.0 Informix Wire Protocol;HostName=MyInformixHost;PortNumber=4321;
ServerName=Acct;Database=Payroll;LogonID=jsmith;Password=secret;