pdo_dblib-dsn(3) [php man page]

PDO_DBLIB-DSN(3)							 1							  PDO_DBLIB-DSN(3)

PDO_DBLIB DSN - Connecting to Microsoft SQL Server and Sybase databases

	The PDO_DBLIB Data Source Name (DSN) is composed of the following elements:

	      o DSN prefix
		-  The	DSN  prefix is sybase: if PDO_DBLIB was linked against the Sybase ct-lib libraries, mssql: if PDO_DBLIB was linked against
		the Microsoft SQL Server libraries, or dblib: if PDO_DBLIB was linked against the FreeTDS libraries.

	      o host - The hostname on which the database server resides. Defaults to 127.0.0.1.

	      o dbname - The name of the database.

	      o charset - The client character set.

	      o appname - The application name (used in sysprocesses). Defaults to "PHP Generic DB-lib" or "PHP freetds".

	      o secure - Currently unused.

       Example #1

	      PDO_DBLIB DSN examples

	       The following examples show a PDO_DBLIB DSN for connecting to Microsoft SQL Server and Sybase databases:

	      mssql:host=localhost;dbname=testdb
	      sybase:host=localhost;dbname=testdb
	      dblib:host=localhost;dbname=testdb

PHP Documentation Group 													  PDO_DBLIB-DSN(3)

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)