DB2 Version 10.1 for Linux, UNIX, and Windows

DB2ConnectionStringBuilder 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.

Version information

Last update: This topic was last updated for: IBM DB2 Version 9.7
.NET Framework version: Supported in: 2.0, 3.0, 3.5 and 4.0
IBM Data Server Client: Supported in: IBM DB2 Version 9