php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Doc Bug #78074 PDO_OCI not working
Submitted: 2019-05-27 10:05 UTC Modified: 2019-06-01 08:42 UTC
From: berger at gmx dot de Assigned: cmb (profile)
Status: Closed Package: PDO OCI
PHP Version: 7.3.6RC1 OS: Windows 10
Private report: No CVE-ID: None
View Developer Edit
 [2019-05-27 10:05 UTC] berger at gmx dot de 
Description:
------------
Cannot get the oracle driver working with php (7.1 & 7.3.7-dev).

DSN-String is: oci://hostname:port/dbname

Error message is: Uncaught PDOException: could not find driver in ...

Line "extension=php_pdo_oci.dll" is activated in php.ini

phpinfo() shows:

    PDO drivers	 mysql, pgsql, sqlsrv







Test script:
---------------
Uncomment line "extension=php_pdo_oci.dll" in php.ini

Then run phpinfo() and go to "PDO"-Section.

Expected result:
----------------
PDO OCI (Oracle) Driver active and running

Actual result:
--------------
PDO OCI (Oracle) Driver not loaded and running

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2019-05-27 10:29 UTC] cmb@php.net
-Status: Open +Status: Feedback -Assigned To: +Assigned To: cmb
 [2019-05-27 10:29 UTC] cmb@php.net 
Do you have the appropriate OCI.DLL in your path?
 [2019-05-27 10:55 UTC] berger at gmx dot de
-Status: Feedback +Status: Assigned
 [2019-05-27 10:55 UTC] berger at gmx dot de 
I don't know what exactly you mean with that question?

There is a "php_pdo_oci.dll" in the "ext"-subdirectory. I have not installed third party drivers. This was not necessary for the other DB-Systems (mysql & postgre) either. For Microsoft SQL Server I had to download the driver manually from microsoft and after putting the dll into the ext-path and registering it within the php.ini everything worked fine.

Just the (prepackaged) oracle driver doesn't want to work.
 [2019-05-27 11:10 UTC] cmb@php.net 
For oci and pdo_oci, you need to install the Oracle instant
client[1].  The documentation needs to be improved in this regard.

[1] <https://www.oracle.com/technetwork/topics/winsoft-085727.html>
 or <https://www.oracle.com/technetwork/topics/winx64soft-089540.html>
 [2019-05-27 11:11 UTC] cmb@php.net
-Type: Bug +Type: Documentation Problem
 [2019-06-01 08:41 UTC] cmb@php.net 
Automatic comment from SVN on behalf of cmb
Revision: http://svn.php.net/viewvc/?view=revision&amp;revision=347520
Log: Fix #78074: PDO_OCI not working
 [2019-06-01 08:42 UTC] cmb@php.net
-Status: Assigned +Status: Closed
 [2019-06-01 08:42 UTC] cmb@php.net 
This bug has been fixed in the documentation's XML sources. Since the
online and downloadable versions of the documentation need some time
to get updated, we would like to ask you to be a bit patient.

Thank you for the report, and for helping us make our documentation better.
 [2019-06-01 08:45 UTC] salathe@php.net 
Automatic comment on behalf of cmb
Revision: http://git.php.net/?p=doc/en.git;a=commit;h=3ebba882578cd1d736c389e35c9c466b64c32558
Log: Fix #78074: PDO_OCI not working
 [2020-02-07 06:05 UTC] phpdocbot@php.net 
Automatic comment on behalf of cmb
Revision: http://git.php.net/?p=doc/en.git;a=commit;h=537e6eeb269cf03277df4c947fccf8e2a8d944bf
Log: Fix #78074: PDO_OCI not working
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat Dec 21 14:01:32 2024 UTC