PDO_OCI DSN
(PECL PDO_OCI >= 0.1.0)
PDO_OCI DSN — Connecting to Oracle databases
Description
The PDO_OCI Data Source Name (DSN) is composed of the following elements:
- DSN prefix
-
The DSN prefix is
oci:
. -
dbname
(Oracle Instant Client) -
The URI for the Oracle Instant Client connection takes the form of
dbname=//hostname:port-number/database
. If you are connecting to a database defined in tnsnames.ora, use only the name of the database:dbname=database
. -
charset
-
The client-side character set for the current environment handle.
Examples
Example #1 PDO_OCI DSN examples
The following examples show a PDO_OCI DSN for connecting to Oracle databases:
// Connect to a database defined in tnsnames.ora oci:dbname=mydb // Connect using the Oracle Instant Client oci:dbname=//localhost:1521/mydb