PHP: PDO_IBM DSN - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

ibm_db2 IBM (PDO)

Last updated: Fri, 26 Jan 2007

view this page in

# PDO_IBM DSN

(no version information, might be only in CVS)

PDO_IBM DSN -- Connecting to IBM databases

## Описание

The PDO_IBM Data Source Name (DSN) is based on the IBM CLI DSN. The major components of the PDO_IBM DSN are:

DSN prefix

  The DSN prefix is `ibm:`.

`DSN`

  The DSN can be any of the following:

  - a) Data source setup using `db2cli.ini` or `odbc.ini`

  - b) Catalogued database name i.e. database alias in the DB2 client catalog

  - c) Complete connection string in the following format: `DRIVER={IBM DB2 ODBC DRIVER};DATABASE=`database`;HOSTNAME=`hostname`;PORT=`port`;PROTOCOL=TCPIP;UID=`username`;PWD=`password`;` where the parameters represent the following values:

    `database`

      The name of the database.

    `hostname`

      The hostname or IP address of the database server.

    `port`

      The TCP/IP port on which the database is listening for requests.

    `username`

      The username with which you are connecting to the database.

    `password`

      The password with which you are connecting to the database.

## Примеры

Пример 1. PDO_IBM DSN example using `db2cli.ini`

The following example shows a PDO_IBM DSN for connecting to an DB2 database cataloged as DB2_9 in `db2cli.ini`:

    $db = new PDO("ibm:DSN=DB2_9", "", "");

    [DB2_9]
    Database=testdb
    Protocol=tcpip
    Hostname=11.22.33.444
    Servicename=56789

Пример 2. PDO_IBM DSN example using a connection string

The following example shows a PDO_IBM DSN for connecting to an DB2 database named `testdb` using the DB2 CLI connection string syntax.

    $db = new PDO("ibm:DRIVER={IBM DB2 ODBC DRIVER};DATABASE=testdb;" .
      "HOSTNAME=11.22.33.444;PORT=56789;PROTOCOL=TCPIP;", "testuser", "tespass");

add a note User Contributed Notes
PDO_IBM DSN
There are no user contributed notes for this page.
ibm_db2 IBM (PDO)

Last updated: Fri, 26 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 11:33:19 2007 PST