HP Vertica driver for ADO.NET Connection Strings

Vertica

Standard connection

Host=node01;Database=VMart;User=dbadmin;

Using password

Host=node01;Database=VMart;User=dbadmin;Password=usersPassword;

Specify a specific TCP/IP port

Host=node01;Database=VMart;User=dbadmin;Port=5433;

Label the connection for server side identification

Host=node01;Database=VMart;User=dbadmin;Label=thisOrThatApp;

Secure SSL connection

Host=node01;Database=VMart;User=dbadmin;SSL=true;

Enable connection pooling

Host=node01;Database=VMart;User=dbadmin;Pooling=true;

Set connection pool load balance time out

Host=node01;Database=VMart;User=dbadmin;Pooling=true;LoadBalanceTimeout=3600;

When pool is full and no timeout is specified no new connections can enter the pool. Therefore newly added servers in a cluster will never be hit. The LoadBalanceTimeout value is specified in seconds.

Read only connection

Host=node01;Database=VMart;User=dbadmin;ReadOnly=true;