DB2 .NET Data Provider Connection Strings

IBM DB2

Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword;

The Server key value syntax is a server name / ip address and an optional port number (note the : in between).

Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword;Max Pool Size=100;Min Pool Size=10;

Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword;Pooling=false;

Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword;Connection Lifetime=60;

Defines how many seconds the connection can remain idle in the pool before its removed from the pool.

Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword;Connection Reset=false;

Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword;CurrentSchema=mySchema;

All unqualified SQL objects used with the current connection will be qualified with the provided schema name