PDO_ODBC DSNConnecting to ODBC or DB2 databases DescriptionThe PDO_ODBC Data Source Name (DSN) is composed of the following elements:
Examples
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 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 odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\\db.mdb;Uid=Admin |