Table of Contents Previous Next


5 Using the .NET Connector : 5.1 Opening a Database Connection : 5.1.1 Connection String Parameters

CommandTimeout specifies the length of time (in seconds) to wait for a command to finish execution before throwing an exception. The default value is 20.
Use ConnectionLifeTime to specify the length of time (in seconds) to wait before closing unused connections in the pool. The default value is 15.
Use the Database parameter to specify the name of the database to which the application should connect. If a database name is not specified, the database name will default to the name of the connecting user.
The Encoding parameter is obsolete; the parameter always returns the string unicode, and silently ignores attempts to set it.
By default, Integrated Security is set to false, and Windows Integrated Security is disabled. Specify a value of true to use Windows Integrated Security.
MaxPoolSize instructs EDBConnection to dispose of pooled connections when the pool exceeds the specified number of connections. The default value is 20.
MinPoolSize instructs EDBConnection to pre-allocate the specified number of connections with the server. The default value is 1.
By default, Pooling is set to true to enable connection pooling. Specify a value of false to disable connection pooling.
The Port parameter specifies the port to which the application should connect.
Use the SearchPath parameter to change the search path to named and public schemas.
By default, SSL is set to false; specify a value of true to attempt a secure connection.
Use sslmode to specify an SSL connection control preference. sslmode can be:
prefer - Use SSL if possible.
require - Throw an exception if an SSL connection cannot be established.
allow - Connect without SSL. This parameter is not supported.
disable - Do not attempt an SSL connection. This is the default behavior.
Use the SyncNotification parameter to specify that EDBDataprovider should use synchronous notifications. The default value is false.
Timeout specifies the length of time (in seconds) to wait for an open connection. The default value is 15.
User Id
The User Id parameter specifies the user name that should be used for the connection.

5 Using the .NET Connector : 5.1 Opening a Database Connection : 5.1.1 Connection String Parameters

Table of Contents Previous Next