PHP Manual
Prev |  | Next

# PDO_INFORMIX DSN

(no version information, might be only in CVS)

PDO_INFORMIX DSN -- Connecting to Informix databases

## Description

The PDO_INFORMIX Data Source Name (DSN) is based on the Informix ODBC DSN string. Details on configuring an Informix ODBC DSN are available from the Informix Dynamic Server Information Center. The major components of the PDO_INFORMIX DSN are:

DSN prefix

  The DSN prefix is `informix:`.

`DSN`

  The DSN can be either a data source setup using `odbc.ini` or a complete connection string.

## Examples

Example 1. PDO_INFORMIX DSN example using `odbc.ini`

The following example shows a PDO_INFORMIX DSN for connecting to an Informix database cataloged as Infdrv33 in `odbc.ini`:

    $db = new PDO("informix:DSN=Infdrv33", "", "");

    [ODBC Data Sources]
    Infdrv33=INFORMIX 3.3 32-BIT

    [Infdrv33]
    Driver=/opt/informix/csdk_2.81.UC1G2/lib/cli/iclis09b.so
    Description=INFORMIX 3.3 32-BIT
    Database=common_db
    LogonID=testuser
    pwd=testpass
    Servername=ids_server
    DB_LOCALE=en_US.819
    OPTIMIZEAUTOCOMMIT=1
    ENABLESCROLLABLECURSORS=1

Example 2. PDO_INFORMIX DSN example using a connection string

The following example shows a PDO_INFORMIX DSN for connecting to an Informix database named `common_db` using the Informix connection string syntax.

    $db = new PDO("informix:host=host.domain.com; service=9800;
        database=common_db; server=ids_server; protocol=onsoctcp;
        EnableScrollableCursors=1", "testuser", "tespass");

Prev | Home | Next
Informix Functions (PDO_INFORMIX) | Up | Ingres II Functions