调用未定义的函数 oci_connect、php_oci8_12c.dll、windows 8.1、php5.6.6

本文介绍了调用未定义的函数 oci_connect、php_oci8_12c.dll、windows 8.1、php5.6.6的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着跟版网的小编来一起学习吧！

问题描述

我有一个简单的 php 脚本:

I have a simple php script:

<?php
$db_user = 'myusername';
$db_pass = 'mypassword';
$db_sid = 'mysid';
$conn = oci_connect( $db_user, $db_pass, $db_sid );
?>

当我运行它时(从浏览器或命令行)，我收到错误:

When I run it (from a browser or from the command line), I get the error:

Call to undefined function oci_connect

我正在使用 php_oci8_12c.dll 附带的 php 5.6.6.

I'm using php 5.6.6 which came with php_oci8_12c.dll already there.

我的 php.ini 中有 extension=php_oci8_12c.dll

I have extension=php_oci8_12c.dll in my php.ini

我已经安装了 Instant Client (12.1) - 尝试了 32 位版本和 64 位版本

I have installed instant client (12.1) - tried 32 bit version AND 64 bit version

我有指向即时客户端文件夹 ( C:instantclient_12_1 ) 的 ORACLE_HOME 和 TNS_ADMIN 环境变量.

I have ORACLE_HOME and TNS_ADMIN environment variables pointing at the instant client folder ( C:instantclient_12_1 ).

我的路径中也有 C:instantclient_12_1

I also have C:instantclient_12_1 in my path

我在同一个文件夹中有一个 tnsnames.ora，其中包含此相关条目:

I have a tnsnames.ora in that same folder with this relevant entry in it:

MYSID =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = myhost.net)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = MYSERVICE)
    )
  )

我还从 http://下载了 SQLDeveloperwww.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

SQLDeveloper 工作，识别上面提到的 tnsnames.ora 并连接并成功地在我的 php 脚本试图访问的同一个数据库上运行查询.

SQLDeveloper works, recognizes the above mentioned tnsnames.ora and connects and successfully runs a query on the same database that my php script is trying to access.

几天来，我花了几个小时尝试不同的事情，但都无济于事.

I have spent several hours over several days trying different things to no avail.

我正在使用:

php 5.6.6
windows 8.1
IIS (so no answers involving apache please)
cmd (run as administrator)
Oracle Database 11g Enterprise Edition 11.2.0.3.0

其他一些可能有用的信息:

Some other information that might prove useful:

理想情况下，我希望使用 oci 1.4.10 来匹配生产服务器，但现在不太担心.

I would ideally like to use oci 1.4.10 to match the production server, but not too worried about that for now.

pear install oci8-1.4.10.tgz

给我这个错误:

The DSP oci8.dsp does not exist

我找不到任何对我有意义的错误的解释.

I can't find any explanation on that error that means anything to me.

我错过了什么 - 谁能帮帮我

What am I missing - can anyone help me

我已经尝试了其他关于 stackoverflow 的帖子中的各种建议，即:

I have tried the various suggestions in other posts on stackoverflow, namely:

extension=oci8.so 有和没有 extension=php_oci8_12c.dll

我的 php.ini 文件中没有 extension=php_oracle.dll 行

I don't have the line extension=php_oracle.dll in my php.ini file

phpinfo 告诉我我使用的是正确的 php.ini 文件:

phpinfo tells me that I am using the correct php.ini file:

Loaded Configuration File => C:php5.6.6php.ini

phpinfo 中的这一行也可能有用:

This line from phpinfo might also be of use:

Configure Command => cscript /nologo configure.js  "--enable-snapshot-build" "--enable-debug-pack" "--disable-zts" "--disable-isapi" "--disable-nsapi" "--without-mssql" "--without-pdo-mssql" "--without-pi3web" "--with-pdo-oci=c:php-sdkoraclex86instantclient_12_1sdk,shared" "--with-oci8-12c=c:php-sdkoraclex86instantclient_12_1sdk,shared" "--with-enchant=shared" "--enable-object-out-dir=../obj/" "--enable-com-dotnet=shared" "--with-mcrypt=static" "--without-analyzer" "--with-pgo"

似乎 dsp 文件是 VC++ 项目文件 - 我现在正在冒险学习如何创建 php 扩展，希望当我完成后我将有足够的知识将 oci8 1.4.10 源代码编译成一个适用于 Windows 8 的 dll - 除非有人用这个问题的答案来拯救我 - 这看起来需要我一些时间:-)

It seems that dsp files are VC++ project files - I am now venturing on learning how to create a php extension, and hopefully when I've done that I'll have enough knowledge to compile the oci8 1.4.10 source code into a dll that works on windows 8 - unless somebody rescues me with the answer to this question - this looks like it is going to take me some time :-)

向 php.ini 添加 display_startup_errors = On 告诉我 oci dll 不是有效的 Win32 应用程序

Adding display_startup_errors = On to php.ini tells me that the oci dll is not a valid Win32 application

调用未定义的函数 oci_connect、php_oci8_12c.dll、windows 8.1、php5.6.6

问题描述

推荐答案

相关文档推荐