BEA Informix Driver Properties

You can specifiy the following connectivity properties for your Informix database:

Basic

Property	Description
Host	Specifies either the IP address or the server name (if your network supports named servers) of the primary database server. For example, 122.23.15.12 or InformixServer.
Port	Specifies the TCP port on which the database server listens for connections. The default varies depending on operating system.
User	Specifies the case-insensitive default user name used to connect to your Informix database.
Password	Specifies a case-insensitive password used to connect to your Informix database.
Database	Specifies the name of the database to which you want to connect.
Server	Specifies the name of the Informix database server to which you want to connect.
URL	Defines the URL format used to connect to your database.

Advanced

Property	Description
Root dbspace name	Specifies the root dbspace of your Informix database. The rootdb space is the initial dbspace created by the Informix server. The root dbspace contains reserve pages and internal tables.

Properties

You can define name/value pairs to provide additional configuration properties to your database. See your vendor's documentation for more information.

Note: Connection property names are case-insensitive.

Runtime

Property	Description
Maximum Pool Size	Determines the maximum number of connections that can be created within the connection pool.
Maximum Connections Per User	Determines the maximum number of connections that can be created per user.
Connection Idle Time (minutes)	Specifies the maximum time, in minutes, that a database connection can remain idle before it is closed automatically.
Minimum Pool Size	Determines the minimum number of connections that can be created within a connection pool.
Maximum Opened Cursors	Determines the maximum number of cursors that can be opened at one time.

Parent topic: SQL Database