Database Connection Settings

Specify database connection parameters in the Database Configuration window or Properties window.

The Database Configuration window appears when you add a component to the Design window, or when you double-click an existing project component.
The Properties window appears when you select a project component in the Design window.

The database connection parameters are:

Interface – select the method or driver you want to use to connect to the destination or source database. To set special database options, click the Database options icon.

Note:
Sybase Open Client™ must be installed on the same computer as Sybase IQ InfoPrimer Development, and the database server must be defined in the %SYBASE%\ini\sql.ini file on Windows, and in the $SYBASE/interfaces file on UNIX and Linux. If you are executing a project on an IQ InfoPrimer Server, the server must also have access to Open Client libraries.
The available interfaces for a component can be one or more of:
- Sybase
- ODBC – the ODBC driver must be installed on the same computer as Sybase IQ InfoPrimer Development, and a system datasource name (DSN) must be defined for the target. If the project is to be executed on an IQ InfoPrimer Server, the IQ InfoPrimer Server must also have access to the proper ODBC drivers and DSN.
- OLE DB
- Oracle
- DB2
- SQLite Persistent
Host Name – select the source or destination database. The options that appear depend on the selected interface.

Note:
If you selected the SQLite Persistent interface, you can enter an existing or new database file name.
Database user name and password
Database name
Database schema – specify schema or owner to restrict the objects shown and create new tables in that schema.
Standardize data formats – convert incoming date and number information into a standard format, which Sybase IQ InfoPrimer can move between systems that support different formats.
Database options – override performance defaults and control the behavior of some transactions. For a list of database options, see Interface-specific database options.