Connection overrides

Relational database connection parameters

  • database - folder containing data files
  • server - name or IP address of the database server
  • port - server port used to connect
  • username - database user
  • password - user's password

ODBC connection parameters

  • odbcConnectMode - should we use saved ODBC connection or specify a connection string directly? (DSN/Connection string)
  • dsn - saved ODBC connection
  • odbcConnString - connection string
  • username - database user
  • password - user's password

Access

  • database - ACCDB or MDB database file
  • password - database password
  • access_sysdb - system database file
  • access_syslogin - system database username
  • access_syspassword - system database password

Azure SQL Database

  • server - full path to the database in the cloud (database-identifier.database.windows.net)
  • username - database user
  • password - user's password
  • database - name of Azure database
  • encrypted - true if connection should be encrypted
  • trust_server_certificate - true if we should trust server certificate

CSV

  • database - folder containing data files

DB2

  • standard relational connection parameters, listed on top of this page

DBF (Clipper, dBase, FoxBase, Visual FoxPro)

  • database - folder containing data files
  • charset - character set

Derby

  • database - folder containing data files

Excel

  • database - folder containing data files
  • first_row_columns - first row contains column names (true/false)

FileMaker

  • standard ODBC connection parameters, listed on top of this page

Firebird

  • standard relational connection parameters, listed on top of this page
  • sqlDialect - database dialect (1 or 3)
  • charset - character set used to encode data
  • client_library - full path to FBCLIENT.DLL
  • role - user role

Gupta

  • standard relational connection parameters, listed on top of this page

H2

  • database - full path to database file, without .mv.db extension
  • username - database user
  • password - user's password

HSQLDB

  • database - full path to database file, without extension
  • username - database user
  • password - user's password

Informix

  • standard ODBC connection parameters, listed on top of this page 

Ingres

  • standard relational connection parameters, listed on top of this page

Interbase

  • standard relational connection parameters, listed on top of this page
  • sqlDialect - database dialect (1 or 3)
  • charset - character set used to encode data
  • client_library - full path to GDS32.DLL or IBCLIENT64.DLL, depending on application architecture
  • role - user role

SQLExpress LocalDB

  • database - full path to .MDF database file
  • isWinAuth - true if Windows authentication is to be used, false if username/password combination
  • username - database user
  • password - user's password

MySQL & MariaDB

  • standard relational connection parameters, listed on top of this page

NexusDB

  • database - folder containing data files
  • username - database user
  • password - user's password

ODBC

  • standard ODBC connection parameters, listed on top of this page

Oracle

  • oracleDirect - true if connecting directly, false if connecting via Oracle Client (OCI)
  • sid_mode - service_name/sid
  • oracleConnectMode - authentication mode (Default/SysDba/SysOper)
  • database - folder containing data files
  • server - name or IP address of the database server
  • port - server port used to connect
  • username - database user
  • password - user's password

Oracle RDB

  • standard relational connection parameters, listed on top of this page

Paradox

  • database - folder containing data files
  • charset - character set

Pervasive

  • standard relational connection parameters, listed on top of this page

PostgreSQL

  • standard relational connection parameters, listed on top of this page

Progress

  • standard ODBC connection parameters, listed on top of this page

QuickBooks

  • standard ODBC connection parameters, listed on top of this page

SQL Compact (SQLCE)

  • database - full path to .SDF database file
  • password - user's password
  • max_db_size - maximum database file size in MB

SQL Server

  • server - name or IP address of the database server (if non-default instance is used, specify SERVERNAME\INSTANCENAME here)
  • isWinAuth - true if Windows authentication is to be used, false if username/password combination
  • username - database user
  • password - user's password
  • database - database name
  • netlib - network library to use (<default>, Named pipes, TCP/IP, Shared memory)
  • encrypted - true if connection should be encrypted
  • trust_server_certificate - true if we should trust server certificate

SQLite

  • database - full path to database file
  • password - user's password

Sybase Adaptive Server (ASE)

  • standard relational connection parameters, listed on top of this page 

Sybase Advantage

  • database - folder containing data files
  • charset - character set used to encode data

Sybase SQL Anywhere (ASA)

  • server - name or IP address of the server computer
  • sybaseServerName - name of ASA database server
  • database - name of ASA database
  • username - database user
  • password - user's password
  • charset - character set used to encode data

Vertica

  • standard relational connection parameters, listed on top of this page 

VistaDB

  • database - full path to .vdb5 database file
  • password - encryption key