%META:TOPICPARENT{name="InstallConfigADONETProviders"}% = 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). %TOC% == Connect String Format == {{{ "Host=[:][;Port=] [;{Server Type|ServerType|SVT}=] [;{Initial Catalog|DATABASE}=] [;{User ID|UID}=][;{Password|PWD}=] [;{Connect Timeout|Connection Timeout}=] [;Persist Security Info=] [;Connection Lifetime=] [;Min Pool Size=] [;Max Pool Size=] [;Pooling=][;Charset=] [;{Read Only|ReadOnly}=] [;{Fetch Buffer Size|FBS|FetchBufferSize}=] [;{Defer Long Fetch|DLF|DeferLongFetch}=] [;Encrypted=] [;Options=] [;UNICODE=] [;APPLICATION=""];" [;MaxRows=];" [;SVAST=];" [;NoRowSetSizeLimit=];" }}} == Connect String Attribute Details == | **Keyword** | **Description** | **Default Value** | | User ID %BR%or%BR% UID | Database username. | "" | | Password %BR%or%BR% PWD | Database password. | "" | | Initial Catalog %BR%or%BR% DATABASE | Takes a database or schema name, or an Oracle SID. | "" | | Connect Timeout %BR%or%BR% 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 {{{:}}}, 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 %BR%or%BR% 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 %BR%or%BR% FBS %BR%or%BR% FetchBufferSize | Integer value to determine the number of rows to buffer in each fetch. Values range from 1 to 999. | 100 | | Server Type %BR%or%BR% ServerType %BR%or%BR% 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 %BR%or%BR% DLF %BR%or%BR% 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 [[MTServerConfigConnectOptions| 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;" }}}