DB2®ConnectionStringBuilder Class

Represents a simple approach for generating valid connection strings for use with the DB2ConnectionString class.

Namespace:: IBM.Data.DB2
Assembly:: IBM.Data.DB2 (in IBM.Data.DB2.dll)

Inheritance hierarchy

System.Object
System.Data.Common.DbConnectionStringBuilder
IBM.Data.DB2.DB2ConnectionStringBuilder

Syntax


[Visual Basic]
Public NotInheritable Class DB2ConnectionStringBuilder
	Inherits DbConnectionStringBuilder
[C#]
public sealed class DB2ConnectionStringBuilder : DbConnectionStringBuilder
[C++]
public ref class DB2ConnectionStringBuilder sealed : 
  public DbConnectionStringBuilder
[JScript]
public final class DB2ConnectionStringBuilder extends DbConnectionStringBuilder

Remarks

This class enables you to create syntactically correct connection strings for your DB2Connection objects by checking that the key/value pairs provided are valid. You can also use this class to validate existing connection strings, and repair them, if required.

Example

[C#] The following example shows how to use a DB2ConnectionStringBuilder instance to generate a valid DB2ConnectionString.

Note: User ID and password information are included in this example for demonstration purposes. You should not hard-code this information in your applications.


[C#]
   DB2ConnectionStringBuilder connStringBld = new DB2ConnectionStringBuilder();
   connStringBld.Database = "SAMPLE";
   connStringBld.UserID = "Jack";
   connStringBld.Password = "BlueJays";
   connStringBld.Server = "jacksserver:db2c_DB2";

   DB2Connection conn = new DB2Connection(connStringBld.ConnectionString);

Thread safety

Any public static (Shared in Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.