PHP: PDO_OCI DSN - Manual

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

search for in the

Output Control Oracle (PDO)

Last updated: Fri, 26 Jan 2007

view this page in

# PDO_OCI DSN

(no version information, might be only in CVS)

PDO_OCI DSN -- Connecting to Oracle databases

## Описание

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.

## Примеры

Пример 1. PDO_OCI DSN examples

The following examples show a PDO_OCI DSN for connecting to Oracle databases:

    oci:mydb
    oci:dbname=//localhost:1521/mydb

add a note User Contributed Notes
PDO_OCI DSN
Alexander Ashurkoff
26-Feb-2007 02:20
`If you want to use PDO_OCI and get proper russian windows-1251 codepage, just add charset=CL8MSWIN1251 to your DSN.
example:
<?php
$dbc = new PDO('oci:dbname=192.168.10.145/orcl;charset=CL8MSWIN1251', 'username', 'password');
?>
Аlso setting apache/registry/system environment variable NLS_LANG to RUSSIAN_CIS.CL8MSWIN1251 may helps you.`
Helpful User
11-Oct-2006 05:59
`If you get the error: TNS: could not resolve service name
Remember that the PDO wants to use the default client, which will only use the tnsnames.ora in %ORACLE_HOME%\network\admin. Check that file and make sure your service is defined in there.
BTW, there is a bug with pdo_oci8 with 9i - don't use it. Make sure you just use pdo_oci.dll.`
add a note
Output Control Oracle (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