PDO_INFORMIX-DSN(3)							 1						       PDO_INFORMIX-DSN(3)

PDO_INFORMIX DSN - Connecting to Informix databases

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

	      o DSN prefix
		- The DSN prefix is informix:.

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

       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");

PHP Documentation Group 												       PDO_INFORMIX-DSN(3)