Building Connect Strings for the Multi-Tier Generic Client 100% Managed ADO.NET Data Provider (OpenLink.Data.GenericClient)

This Provider connects ADO.NET client applications to our Multi-Tier server components (Request Broker and target-specific Database Agents).

Connect String Format

"Host=<Hostname>[:<portnumber>][;Port=<portnumber>]
   [;{Server Type|ServerType|SVT}=<ServerType>]
   [;{Initial Catalog|DATABASE}=<schema>]
   [;{User ID|UID}=<uid>][;{Password|PWD}=<pwd>]
   [;{Connect Timeout|Connection Timeout}=<seconds>]
   [;Persist Security Info=<boolean>]
   [;Connection Lifetime=<seconds>]
   [;Min Pool Size=<connections>]
   [;Max Pool Size=<connections>]
   [;Pooling=<boolean>][;Charset=<codepage>]
   [;{Read Only|ReadOnly}=<boolean>]
   [;{Fetch Buffer Size|FBS|FetchBufferSize}=<rows>]
   [;{Defer Long Fetch|DLF|DeferLongFetch}=<boolean>]
   [;Encrypted=<boolean>]
   [;Options=<as in ODBC connect string>]
   [;UNICODE=<boolean>]
   [;APPLICATION=""];"
   [;MaxRows=<integer>];"
   [;SVAST=<boolean>];"
   [;NoRowSetSizeLimit=<boolean>];"

Connect String Attribute Details

Keyword Description Default Value
User ID
or
UID
Database username. ""
Password
or
PWD
Database password. ""
Initial Catalog
or
DATABASE
Takes a database or schema name, or an Oracle SID. ""
Connect Timeout
or
Connection Timeout
15
Persist Security Info False
Connection Lifetime 0
Min Pool Size 0
Max Pool Size 100
Pooling True
Charset ""
Host The fully-qualified domain name (FQDN) or IP address of the machine hosting the OpenLink Request Broker. May include the Port value, using the form <Host>:<Port>, e.g., brokerhost.example.com:5000. localhost
Port The TCP port number at which the OpenLink Request Broker listens. Required if not included in the Host value. 5000
Read Only
or
ReadOnly
Make the session read-only. Acceptable values are Yes and No. No may be necessary to run stored procedures in some environments. False
Fetch Buffer Size
or
FBS
or
FetchBufferSize
Integer value to determine the number of rows to buffer in each fetch. Values range from 1 to 999. 100
Server Type
or
ServerType
or
SVT
The value must match a [Domain Alias] found in the Server's Rulebook. Default Aliases typically represent the name and version of a Database Agent. That agent version may differ from the DBMS version to which it connects. Advanced users may create custom domain names that follow their own, desired conventions. ""
Defer Long Fetch
or
DLF
or
DeferLongFetch
Defers fetching of LONG (BINARY, BLOB, CLOB, etc.) fields unless explicitly requested in a query. This can provides significant performance increases when fields in query do not include LONG data fields. Possible values are YES and NO. False
Encrypted Activates a simple encryption for communications between the Generic Client and the Request Broker. False
Options Passes many connection options including parameters that enable three-tier connections, i.e., connections to DBMS that do not reside on the same machine as the OpenLink Request Broker and Database Agent. Review Complete Settings and Usage for DBMS-specific Connect Options. ""
UNICODE False
APPLICATION "opldotNET"
MaxRows Integer value to limit the number of returned rows. ""
SVAST Present system views as if they were system tables. Acceptable values are Yes and No. "No"
NoRowSetSizeLimit Set no restriction on result set sizes, permitting Cartesian products, among other possible issues. Acceptable values are Yes and No. "No"

Sample connect strings

For Oracle 9

"Host=localhost;Port=5000;SVT=Oracle 9.x;DATABASE=ORCL;UID=scott;PWD=tiger;"

For Microsoft SQL Server 2000

"Host=localhost;Port=5000;SVT=SQLServer 2000;DATABASE=Northwind;UID=sa;PWD=;"

For Progress 10 (OpenEdge)

"Host=localhost;Port=5000;SVT=Progress 100SQL;OPTIONS=-S pro102b -H proghost.example.com -N tcp;DATABASE=iSports;UID=sysprogress;PWD=yourpassword;"

Referenced by...