PHP : Function Reference : Informix Functions (PDO_INFORMIX) : PDO_INFORMIX DSN PHP Examples Tutorials References

Example 1080. 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:

copy to clipboard

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

copy to clipboard

[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 1081. 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.

copy to clipboard

$db = new PDO("informix:host=host.domain.com; service=9800;

    database=common_db; server=ids_server; protocol=onsoctcp;

    EnableScrollableCursors=1", "testuser", "tespass");

PDO_INFORMIX DSN

Connecting to Informix databases ()

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

Example 1081. PDO_INFORMIX DSN example using a connection string

Change Language

PDO_INFORMIX DSN

Connecting to Informix databases ()

Example 1080. PDO_INFORMIX DSN example using odbc.ini

Example 1081. PDO_INFORMIX DSN example using a connection string

Change Language

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