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.