• Topic
  • Discussion
  • UdaWikiWeb.STDSNLessStrings(Last) -- Owiki? , 2016-08-19 15:00:54 Edit owiki 2016-08-19 15:00:54

    DSN-less ODBC Connect String Details for Single-Tier "Lite" Edition Drivers

    Common to all Lite Edition Drivers

    • NoAutoCommit — Tells the driver whether to treat each SQL statement as its own transaction ("No"), or to treat the entire database session as a single transaction ("Yes"). The latter setting allows the client application to manage transactions itself. Acceptable values are Yes and No.
    • Jet — Enable Microsoft Jet Engine compatibility features. Acceptable values are Yes and No.
    • NoRowSetSizeLimit — Set no restriction on result set sizes, permitting Cartesian products, among other possible issues. Acceptable values are Yes and No.
    • IntialSQL — Points to a file containing one or more SQL statements to be executed against the Database on connect.

    Database or Driver Specific

    DB2

    There are no DB2-specific connection attributes. See previous section for common parameters.

    Informix

    • Protocol — Informix protocol identifier.
    • Service — Service name or port number as found in the /etc/services file. If not listed in the /etc/services file, must specify by port number.
    • 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 Open Ingres

    • Database — name of the database alias.
    • IngServer<vnode>::<dbname>.

    Microsoft SQL Server (TDS)

    • TDSHost — The IP address or alias name of the SQL Server host.
    • TDSPort — The TCP port number the SQL Server instance is listening at
    • TDSVer — The TDS Protocol version for the the target SQL Server instance.
    • TDSDBase — The name of the SQL Server Database

    My SQL

    • Host — The IP address or hostname of the machine hosting MySQL.
    • Port — The TCP port number the MySQL instance is listening on.
    • Database — The name of the MySQL database you are connecting 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.

    Postgre SQL

    • Host — The IP address or hostname of the machine hosting PostgreSQL.
    • Port — The TCP port number the PostgreSQL instance is listening on.
    • Database — The name of the PostgreSQL database you are connecting to.

    Progress

    • Options — Valid Progress connection options.
    • TableView — Full path and filename of the tableview file.
    • ServerOptions — Valid Progress server options.
    • SQLNETInterface — Interface DLL or AutoScan for Driver self determination.

    Sybase ASE/ASA (TDS)

    • TDSHost — The IP address or alias name of the Sybase host.
    • TDSPort — The TCP port number the Sybase instance is listening at
    • TDSVer — The TDS Protocol version for the target Sybase instance.
    • TDSDBase — The name of the Sybase schema.

    Referenced by...