skip to main content
Using the ADO.NET Client : Specifying Connection Options
 

Specifying Connection Options

You can modify a connection by specifying connection string options. Refer to the OpenAccess SDK Administrator’s Guide for information about specifying options through the Client’s OpenAccessConnection object.
The basic format of a connection string includes a series of keyword/value pairs separated by semicolons. The following example shows the keywords and values for a simple connection string to connect to the host hal:
"Host=hal;Port=19998;User Id=test01;Password=test01;Database=test;"
Use the following guidelines when specifying a connection string:
All connection string option names are case-insensitive. For example, Password is the same as password. However, the values of options such as User ID and Password may be case-sensitive.
The spaces in the connection string option names are required.
Special characters can be used in the value of the connection string option. To escape special characters, surround the value in double quotes.
The following connection option descriptions are listed alphabetically by the connection string option name. The ConnectionStringBuilder property name is listed immediately underneath the GUI name. For example:
Alternate Servers
Property
AlternateServers
The connection string option name and the property name are the same; however, the spaces in the connection string option name are required.