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.