MTServerConfigConnectOptions Details of Multi-Tier Rulebook ConnectOptions, and Single-Tier and Multi-Tier DSN Options Details of Multi-Tier Rulebook ConnectOptions, and Single-Tier and Multi-Tier DSN Options For connections to DB2 <tgroup><thead /><tbody> <row> </row> <row> <entry> <emphasis><computeroutput><Native DB2 DSN></computeroutput></emphasis> (no flag)</entry> <entry>Pass a native DB2 DSN, if the DB2 DBMS runs on a different machine than the OpenLink Request Broker and Database Agent.</entry> <entry> <computeroutput>My_DB2_DSN</computeroutput></entry> </row> </tbody></tgroup></table> <para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h2"> For connections to Informix </bridgehead> <table><title /><tgroup><thead /><tbody> <row> </row> <row> <entry> <emphasis><computeroutput><Informix Instance Name></computeroutput></emphasis> (no flag)</entry> <entry>Pass an <ulink url="HowCanIFindMyInformixInstanceName">Informix Instance Name</ulink>, if connecting via TCP/IP stack (i.e., not shared memory).</entry> <entry> <computeroutput>inf10inst1</computeroutput></entry> </row> </tbody></tgroup></table> <para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h2"> For connections to Ingres </bridgehead> <table><title /><tgroup><thead /><tbody> <row> </row> <row> <entry> <emphasis><computeroutput><Ingres vnode></computeroutput></emphasis> (no flag)</entry> <entry>Pass an <ulink url="HowCanIFindMyIngresNodeName">Ingres vnode</ulink>, if the Ingres DBMS runs on a different machine than the OpenLink Request Broker and Database Agent.</entry> <entry> <computeroutput>Ing_vnode</computeroutput></entry> </row> </tbody></tgroup></table> <para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h2"> For connections to Microsoft SQL Server </bridgehead> <table><title /><tgroup><thead /><tbody> <row> </row> <row> <entry> <emphasis><computeroutput>-H <hostname or IP address></computeroutput></emphasis> </entry> <entry> <emphasis>Required</emphasis> Fully-qualified domain name (i.e., DNS-resolvable hostname) or IP address of the SQL Server host machine. </entry> <entry> <computeroutput>-H sql-host.example.com</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-V <version></computeroutput></emphasis> </entry> <entry> <emphasis>Required</emphasis> <ulink url="TDSVersionsExplained">TDSVer value</ulink>. Optimal settings are <emphasis><computeroutput>10.0</computeroutput></emphasis> for SQL Server 2008 and later, <emphasis><computeroutput>9.0</computeroutput></emphasis> for SQL Server 2005 , <emphasis><computeroutput>8.0</computeroutput></emphasis> for SQL Server 2000, <emphasis><computeroutput>7.0</computeroutput></emphasis> for SQL Server 7.x. </entry> <entry> <computeroutput>-V 9.0</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-P <port number></computeroutput></emphasis> </entry> <entry> <ulink url="HowDoIFindMySQLServerListenPort">TCP Port at which the target SQL Server instance is listening</ulink>. Not required if <computeroutput>-I</computeroutput> or <computeroutput>-S</computeroutput> is properly set. Required otherwise. </entry> <entry> <computeroutput>-P 1433</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-I <instance-name></computeroutput></emphasis> </entry> <entry> <ulink url="HowDoIFindMySQLServerInstanceName">SQL Server instance name</ulink> on the specified host (<computeroutput>-H</computeroutput>). <emphasis>Only</emphasis> the actual "<computeroutput>InstanceName</computeroutput>". This option should be used in preference to the <computeroutput>-S</computeroutput> option below for connecting to a named instance. </entry> <entry> <computeroutput>-I mssql2k5</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-S <FQDN of database host>\\<instance-name></computeroutput> </emphasis> </entry> <entry> <emphasis><emphasis>Not recommended. <computeroutput>-H</computeroutput> and <computeroutput>-I</computeroutput> are preferred.</emphasis></emphasis> Specifies a target SQL Server instance by combining the host and instance names as "<computeroutput><FQDN>\\<instance></computeroutput>", e.g., "<computeroutput>sql-host.example.com\\demo-instance</computeroutput>". Note the double backslash ("<computeroutput>\\</computeroutput>") required between the host and instance names. </entry> <entry> <computeroutput>-S sql-host.example.com\\mssql2k5</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-F <fail-over server name></computeroutput></emphasis> </entry> <entry> Specifies the fail-over server name for Database Mirroring. </entry> <entry> <computeroutput>-F failover-host.example.com</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-O <value></computeroutput></emphasis> </entry> <entry> Determines whether stored procedures are created on the server for every call to <computeroutput>SQLPrepare()</computeroutput>. Acceptable values are "2" (Full), "1" (Partial, the default), and "0" (None). <ulink url="WhatDoesPrepareMethodDo">Effects of this setting</ulink>. </entry> <entry> <computeroutput>-O 1</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-L <language></computeroutput></emphasis> </entry> <entry> The name of a Microsoft SQL Server-supported national language. The default language is <emphasis>English.</emphasis> </entry> <entry> <computeroutput>-L English</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-C <character set></computeroutput></emphasis> </entry> <entry> The name of the character set the <ulink url="OpenLink">OpenLink</ulink> driver should deliver to the client application, to be translated from the Server's character set. By default, this is taken from the application's environment. <emphasis>Only valid for non-Unicode drivers. Unicode drivers always deliver UCS-2 on Windows and UCS-4 on Mac OS X and Unix-like OS.</emphasis> </entry> <entry> <computeroutput>-C ISO-8859-1</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-A</computeroutput></emphasis> </entry> <entry> Turn off ANSI NULL handling. <ulink url="WhatDoesUSEANSINullsPaddingAndWarningsDo">Effects of this setting</ulink>. </entry> <entry> <computeroutput>-A</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-E</computeroutput></emphasis> </entry> <entry> Require SSL Strong Data Encryption for communications between Database Agent or Lite Driver and SQL Server. <emphasis>If SQL Server is not configured to support SSL, connections will fail.</emphasis> This is not necessary when the SQL Server is configured to require SSL communications; the Agent/Driver automatically support that requirement. </entry> <entry> <computeroutput>-E</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-R</computeroutput></emphasis> </entry> <entry> Require SSL Server Certificate Verification for SSL communications. Has no effect if SSL is not active. Not necessary in most cases. Will cause failure in server-forced SSL connections if <computeroutput>-D</computeroutput> (below) is not also set correctly.</entry> <entry> <computeroutput>-R</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-D <path to file></computeroutput></emphasis> </entry> <entry> Full path including filename of Certificate Authority File to be used for SSL Certificate Verification. </entry> <entry> <computeroutput>/usr/local/certs/auth.caf</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-Z</computeroutput></emphasis> </entry> <entry> Turn on Snapshot Serializable Isolation. </entry> <entry> <computeroutput>-Z</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-M</computeroutput></emphasis> </entry> <entry> Turn on <emphasis>M</emphasis>ultiple <emphasis>A</emphasis>ctive <emphasis>R</emphasis>esult <emphasis>S</emphasis>ets (MARS), enabling concurrent processing of multiple statements, queries, and/or result sets, on a single database connection. </entry> <entry> <computeroutput>-M</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-N <size></computeroutput></emphasis> </entry> <entry> Network Packet Size determines the number of bytes per network packet transferred between the Microsoft SQL Server and the Database Agent or Lite Driver. This attribute can have significant impact on performance. The default, and often optimal, setting is <computeroutput>8000</computeroutput>. The maximum supported by Microsoft SQL Server is <computeroutput>32767</computeroutput>. </entry> <entry> <computeroutput>-N 0</computeroutput> </entry> </row></tbody></tgroup></table> <para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h2"> For connections to MySQL </bridgehead> <table><title /><tgroup><thead /><tbody> <row> </row> <row> <entry> <emphasis><computeroutput>-H <hostname or IP address></computeroutput></emphasis> </entry> <entry> <emphasis>Required</emphasis> Fully-qualified domain name (i.e., DNS-resolvable hostname) or IP address of the MySQL host machine.</entry> <entry> <computeroutput>-H mysql-host.example.com</computeroutput> </entry> </row> </tbody></tgroup></table> <para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h2"> For connections to JDBC Data Sources </bridgehead> <table><title /><tgroup><thead /><tbody> <row> </row> <row> <entry> <emphasis><computeroutput><JDBC Connection URL></computeroutput></emphasis> (no flag) </entry> <entry> <emphasis>Required</emphasis>. Pass a JDBC connect URL as appropriate for the target JDBC Driver. </entry> <entry> <computeroutput>jdbc:openlink://test.example.com:5000/UID=sa/PWD=admin/READONLY=N/FBS=10/SVT=SQLSERVER/DATABASE=pubs/OPTIONS=-H sqlhost.example.com -V 8.0 -P 1433/</computeroutput> </entry> </row> <row> <entry> </entry> <entry> <emphasis>NOTE</emphasis>. The JDBC Driver classname must be passed as the Database DSN attribute, and the associated jar file must be in the active CLASSPATH. </entry> <entry> </entry> </row> </tbody></tgroup></table> <para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h2"> For connections to ODBC Data Sources </bridgehead> <table><title /><tgroup><thead /><tbody> <row> </row> <row> <entry> <emphasis><computeroutput><local ODBC DSN></computeroutput></emphasis> (no flag) </entry> <entry> <emphasis>Required</emphasis>. Pass an ODBC DSN as defined on the Broker host. </entry> <entry> <computeroutput>my_odbc_dsn</computeroutput> </entry> </row> </tbody></tgroup></table> <para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h2"> For connections to Oracle </bridgehead> <table><title /><tgroup><thead /><tbody> <row> </row> <row> <entry> <emphasis><computeroutput><Oracle SQL*Net or Net Service Name></computeroutput></emphasis> (no flag) </entry> <entry> Pass an <ulink url="HowDoIFindMySQLNetOrNetServiceName">Oracle Service Name</ulink>, as defined in <computeroutput>tnsnames.ora</computeroutput>. </entry> <entry> <computeroutput>oracle.example.com</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput><Oracle Connection String></computeroutput></emphasis> (no flag) </entry> <entry> Pass an Oracle connection string. </entry> <entry> <computeroutput>"scott/tiger@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle-host.example.com)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oracle.example.com)))"</computeroutput> </entry> </row> </tbody></tgroup></table> <para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h2"> For connections to PostgreSQL </bridgehead> <table><title /><tgroup><thead /><tbody> <row> </row> <row> <entry> <emphasis><computeroutput>-H <hostname or IP address></computeroutput></emphasis> </entry> <entry> <emphasis>Required</emphasis> Fully-qualified domain name (i.e., DNS-resolvable hostname) or IP address of the PostgreSQL host machine.</entry> <entry> <computeroutput>-H postgresql-host.example.com</computeroutput> </entry> </row> </tbody></tgroup></table> <para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h2"> For connections to Progress / OpenEdge </bridgehead> <para>The following options are not required for Shared Memory-mode connections -- which are only possible with SQL-89 drivers, and only when those drivers have been linked to <emphasis>exactly</emphasis> the same Progress library versions as are installed on the current host.</para><para>These options are <emphasis>all</emphasis> required for Sockets-mode connections. Any connection <emphasis>may</emphasis> be made in sockets mode if Progress instance has been started with this mode enabled.</para><para>Connection <emphasis>must</emphasis> be made in sockets mode when using -- </para><itemizedlist mark="bullet" spacing="compact"><listitem> a Single-Tier Driver (whether SQL-89 or SQL-92), </listitem> <listitem> a SQL-92 Driver (whether Single-Tier or Multi-Tier), </listitem> <listitem> a Multi-Tier Database Agent (whether SQL-89 or SQL-92) that is not located on the same host as the Progress instance, and </listitem> <listitem> a SQL-89 Driver (whether Single-Tier or Multi-Tier) that has not been linked to the exact same Progress library versions as are installed on the current driver host.</listitem> </itemizedlist><table><title /><tgroup><thead /><tbody> <row> </row> <row> <entry> <emphasis><computeroutput>-S <socket service name or port number></computeroutput></emphasis> </entry> <entry> Socket service port number, or associated service name as set in <computeroutput>/etc/services</computeroutput> or equivalent. </entry> <entry> <computeroutput>-S 1234</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-H <hostname or IP address></computeroutput></emphasis> </entry> <entry> Fully-qualified domain name (i.e., DNS-resolvable hostname) or IP address of the Progress host machine. </entry> <entry> <computeroutput>-H progress-host.example.com</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-N tcp</computeroutput></emphasis> </entry> <entry> Always use this value. </entry> <entry> <computeroutput>-N tcp</computeroutput> </entry> </row> </tbody></tgroup></table> <para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h2"> For connections to Sybase </bridgehead> <table><title /><tgroup><thead /><tbody> <row> </row> <row> <entry> <emphasis><computeroutput>-H <hostname or IP address></computeroutput></emphasis> </entry> <entry> <emphasis>Required</emphasis> Fully-qualified domain name (i.e., DNS-resolvable hostname) or IP address of the Sybase host machine. </entry> <entry> <computeroutput>-H sybase-host.example.com</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-V <version></computeroutput></emphasis> </entry> <entry> <emphasis>Required</emphasis> <ulink url="TDSVersionsExplained">TDSVer value</ulink>. Sets the Sybase network protocol version the driver will use to communicate with the target instance. Acceptable values are <emphasis><computeroutput>4.6</computeroutput></emphasis> for Sybase SQL Server 4.x, and <emphasis><computeroutput>5.0</computeroutput></emphasis> for all other Sybase versions. </entry> <entry> <computeroutput>-V 5.0</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-P <port number></computeroutput></emphasis> </entry> <entry> <emphasis>Required</emphasis> <ulink url="HowDoIFindMySybaseListenPort">Sybase listen port</ulink> </entry> <entry> <computeroutput>-P 4100</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-S <instance names></computeroutput></emphasis> </entry> <entry> Sybase instance name. Generally not necessary when host and port are correctly specified, but sometimes required even then. </entry> <entry> <computeroutput>-S MySybaseInstance</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-N <size></computeroutput></emphasis> </entry> <entry> Network Packet Size determines the number of bytes per network packet transferred from the Sybase server to the Database Agent or Lite Driver. This attribute can have significant impact on performance. When set to <computeroutput>0</computeroutput> (default), the driver uses the default packet size as specified in the Sybase server configuration. When set to <computeroutput>-1</computeroutput>, the driver computes the maximum allowable packet size on the first connect to the data source and saves the value in the system information. When set to an integer from 1 to 10, this indicates a multiple of 512 bytes (for example, Packet Size of 6 means to set the packet size to 6 * 512 equal 3072 bytes). For this setting to have any impact, the server must be configured for a maximum network packet size greater than or equal to the value specified here. </entry> <entry> <computeroutput>-N 0</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-C <character set></computeroutput></emphasis> </entry> <entry> The name of the character set the <ulink url="OpenLink">OpenLink</ulink> driver should deliver to the client application, to be translated from the Server's character set. By default, this is taken from the application's environment. <emphasis>Only valid for non-Unicode drivers. Unicode drivers always deliver UCS-2 on Windows and UCS-4 on Mac OS X and Unix-like OS.</emphasis> </entry> <entry> <computeroutput>-C ISO-8859-1</computeroutput> </entry> </row> <row> <entry> <emphasis><computeroutput>-O <value></computeroutput></emphasis> </entry> <entry> Determines whether stored procedures are created on the server for every call to <computeroutput>SQLPrepare()</computeroutput>. Acceptable values are "2" (Full), "1" (Partial, the default), and "0" (None). <ulink url="WhatDoesPrepareMethodDo">Effects of this setting</ulink>. </entry> <entry> <computeroutput>-O 1</computeroutput> </entry> </row> </tbody></tgroup></table> </section></docbook>