Top

5.1.12.Connect String parameters

Common Connect string

You may sometimes be required to build a complete ODBC Connection String to access an ODBC Datasource.

A connection string has the following syntax:

          connection-string ::= empty-string[;] | attribute[;] | attribute; connection-string
          empty-string ::=
          attribute ::= attribute-keyword=attribute-value | DRIVER=[{]attribute-value[}]
          attribute-keyword ::= DSN | UID | PWD | driver-defined-attribute-keyword
          attribute-value ::= character-string
          driver-defined-attribute-keyword ::= identifier

where character-string has zero or more characters; identifier has one or more characters; attribute-keyword is not case-sensitive; attribute-value may be case-sensitive; and the value of the DSN keyword does not consist solely of blanks.

The following list describes valid attributes and their values common to all databases:

  • DSN. Datasource name.

  • UID. Username.

  • PWD. Password.

  • DRIVER. The name of the ODBC Driver to be used. This will be the name displayed in the ODBC Administrator or returned by the SQLDrivers function.

  • ReadOnly. Yes/No - make the session readonly.

  • FetchBufferSize or FBS. 2 digit integer value to determine the number of rows to buffer in each fetch.

  • NoLoginBox or NLB. Yes/No - suppress the authentication dialog box that will appear if either username or password have been omitted.

  • MaxRows. integer value to limit the number of returned rows.

  • NoAutoCommit. Yes/No - define the default behaviour of the driver to adopt.

  • Jet. Yes/No - enable Microsoft Jet Engine compatibility features.

  • NoRowSetSizeLimit. Yes/No

  • SVAST. Yes/No - System views as system tables.

  • IntialSQL. Points to a file containing a list of initial SQL statements to be executed against the Database on connnect.

DB2 Connect string

There is nothing specific to DB2. See above section for common parameters.

Informix Connect string

The following list describes valid attributes and their values that are specific to Informix:

  • Protocol. Informix protocol identifier.

  • Service. Service name as in the etc\services file.

  • Host. hostname of the machine hosting the Informix server.

  • InfServer. Name of the Informix server.

  • Database. name of the database on the Informix server.

  • MultiSess. Yes/No - Multiplex Session.

Ingres and OpenIngres Connect string

The following list describes valid attributes and their values that are specific to Ingres and OpenIngres:

  • Database. name of the database alias.

  • IngServer. <vnode>::<dbname>.

Oracle Connect string

The following list describes valid attributes and their values that are specific to Oracle:

  • OraCatalogs. Yes/No.

  • QuotedIdentifiers. Yes/No.

  • SQLNETConnect. SQL*Net connect string usually just the TNS name.

  • SQLNETInterface. Interface DLL or AutoScan for Driver self determination.

Progress Connect string

The following list describes valid attributes and their values that are specific to Progress:

  • Options. Valid Progress connection options.

  • TableView

    full path and filename to the tableview file.

    See tableview guide for more information.

  • ServerOptions. Valid Progress server options.

  • SQLNETInterface. Interface DLL or AutoScan for Driver self determination.

Microsoft or Sybase SQLServer (TDS) Connect string

The following list describes valid attributes and their values that are specific to Microsoft SQLServer:

  • TDSServer. The IP address or alias name for the server running SQL Server.

  • TDSPort. The TCP port number the SQLServer instance is running on

  • TDSVer. The TDS Protocol version for the type of SQLServer instance being used.

  • TDSDBase. The name of the SQLServer Database

Prev Up Next
5.1.11.PostgreSQL Home 5.1.13.Testing the ODBC Data Source