PDO_ODBC-DSN(3) 1 PDO_ODBC-DSN(3)
PDO_ODBC DSN - Connecting to ODBC or DB2 databases
The PDO_ODBC Data Source Name (DSN) is composed of the following elements:
o DSN prefix
- The DSN prefix is odbc:. If you are connecting to a database cataloged in the ODBC driver manager or the DB2 catalog, you can
append the cataloged name of the database to the DSN.
o DSN
- The name of the database as cataloged in the ODBC driver manager or the DB2 catalog. Alternately, you can provide a complete
ODBC connection string to connect to a database as described at http://www.connectionstrings.com/.
o UID - The name of the user for the connection. If you specify the user name in the DSN, PDO ignores the value of the user name
argument in the PDO constructor.
o PWD - The password of the user for the connection. If you specify the password in the DSN, PDO ignores the value of the password
argument in the PDO constructor.
Example #1
PDO_ODBC DSN example (ODBC driver manager)
The following example shows a PDO_ODBC DSN for connecting to an ODBC database cataloged as testdb in the ODBC driver manager:
odbc:testdb
Example #2
PDO_ODBC DSN example (IBM DB2 uncataloged connection)
The following example shows a PDO_ODBC DSN for connecting to an IBM DB2 database named SAMPLE using the full ODBC DSN syntax:
odbc:DRIVER={IBM DB2 ODBC DRIVER};HOSTNAME=localhost;PORT=50000;DATABASE=SAMPLE;PROTOCOL=TCPIP;UID=db2inst1;PWD=ibmdb2;
Example #3
PDO_ODBC DSN example (Microsoft Access uncataloged connection)
The following example shows a PDO_ODBC DSN for connecting to a Microsoft Access database stored at C:db.mdb using the full ODBC
DSN syntax:
odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\db.mdb;Uid=Admin
PHP Documentation Group PDO_ODBC-DSN(3)