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

where:

host_name

specifies the name or the IP address of the server to which you want to connect.

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.

proxy_user

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

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.

The following example connection string includes the options required for using a proxy server with the user ID/password authentication.

DRIVER=DataDirect 8.0 MySQL Wire Protocol;HostName=MyServer;
ProxyHost=pserver;ProxyPassword=proxys3cr3t;ProxyPort=1234;
ProxyUsert=jsmith;LogonID=jsmith@abc.com;Password=secret;