DataDirect Connect for ADO.NET Data Provider Help

Configuring Connection String Options

Save PDF

Configuring Connection String Options

Save PDF

Last Updated: April 16, 2026
2 minute read

ADO.NET
Documentation

Connection string options can be defined directly in a connection string, or set in the Advanced Properties dialog box in Visual Studio (see Defining Connection String Values in Server Explorer.

Constructing a Connection String

Sybase Data Provider Connection String Options lists the connection string options supported by the Sybase Entity Framework data provider, and describes each option. The options have the form:

option=value

Each connection string option value pair is separated by a semicolon. For example:

"Host=Accounting1;Port=4100;User ID=angela;Password=qu3sts;Database Name=Accounting"

See Using Connection Strings for guidelines for the syntax and use of connection string options.

Default Values for Connection String Options

Sybase Data Provider Connection String Options describes the connection string options. The following table lists the connection string options the Sybase data providers support, along with the default values for each option.

Default Values for Sybase Connection String Options

Connection String Option	Default Value
Alternate Servers	An empty string
Application Name	An empty string
Authentication Method	UserIDPassword
Batch Update Behavior	ArrayBindWhenPossible
Batch Update Parameter Limit	0
Client Host Name	An empty string
Clone Connection if Needed	False
Common Work Arounds	0
Connection Pool Behavior	LeastRecentlyUsed
Connection Reset	False
Connection Retry Count	0
Connection Retry Delay	3
Connection Timeout	15
Database Name	An empty string
Enable Quoted Identifiers	False
Enable Trace	0
Encryption Method	NoEncryption
Enlist	False
Fetch Buffer Size	1024
GSS Client	An empty string
Host	An empty string
Host Name In Certificate	An empty string
Include Procedure Row Count	True
Initial Command Timeout	30
Initialization String	An empty string
Interfaces File	An empty string
License Path	An empty string
Load Balance Timeout	0
Load Balancing	False
Max Pool Size	100
Max Pool Size Behavior	HardCap
Max Statement Cache Size	10
Min Pool Size	0
Packet Size	0
Parameter Mode	ADO.NET data provider: ANSI Entity Framework data provider: BindByName
Password	An empty string
Persist Security Info	False
Pooling	True
Port	4100
Program ID	An empty string
Reader Close Behavior	0
Schema Collection Timeout	120
Schema Options	0x10 or ShowParameterDirections
Select Method	Direct
Server Name	An empty string
Service Principal Name	An empty string
Statement Cache Mode	ExplicitOnly
Text Size	1048576
Tightly Coupled Transactions	True
Trace File	An empty string
Use Current Schema	False
User ID	An empty string
Validate Server Certificate	True
Work Arounds	0

Changes in Default Values for Connection String Options

Most default values of the connection string options used by the ADO.NET Entity Framework Sybase data provider are the same as those used by the Sybase ADO.NET data provider (see SybaseConnection Class for more information). The following table lists the connection string options that have a different default value when used with an ADO.NET Entity Framework application.

Connection String Option Differences with an ADO.NET Entity Framework Application

Connection String Option	Default Value in ADO.NET Entity Framework Application
Parameter Mode	Ignored.
Statement Cache Mode	Only ExplicitOnly is supported.