This string includes the options you may need to connect through a proxy server with basic 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 Aha;HostName=host_name;ProxyHost=proxy_host;
ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;
User=user_name;Password=password;[attribute=value[;...]];

where:

host_name

specifies the base URL of the Aha! service to which you want to issue requests. For example, company.aha.io.

proxy_host

specifies the proxy server to use for the first connection.

proxy_password

specifies the password needed to connect to a proxy server for the first connection.

proxy_port

specifies the port number where the proxy server is listening for requests for the first connection. The default is 0, which means the port number is determined by the setting of the Proxy Host (ProxyHost) option. If an http URL is specified, the default port number is 80. If an https URL is specified, the default is 443.

proxy_user

specifies the user name needed to connect to a proxy server for the first connection.

user_name

specifies the user name that is used to connect to the Aha! service. For example, jsmith@company.com.

password

specifies the password used to connect to your Aha! service.

attribute=value
specifies connection option settings. Multiple option attributes are separated by a semi-colon.
Note: The User 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 required for using a proxy server with basic authentication.

DRIVER=DataDirect 8.0 Aha;HostName=mycompany.aha.io;ProxyHost=pserver;
ProxyPassword=proxys3cr3t;ProxyPort=808;ProxyUsert=jsmith;usr=jsmith@mycompany.com;
password=secret;