Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

PHP 4.4.7 not loading oci8.dll

Posted on 2007-12-03
11
Medium Priority
?
528 Views
Last Modified: 2013-12-18
I have windows 2000 with php 4.4.7 and oracle 10g rel 3.  the ocilogon give me an error function not defined.  when I run php -m from the command line I get the following error.

the procedure entry point ocilobclose could not be locate in the dll OCI.dll

the oci8.dll is not being loaded, hence my error in the php code.  I do not know how to resolve this problem, help.  
0
Comment
Question by:chipbunker
  • 6
  • 3
  • 2
11 Comments
 
LVL 21

Expert Comment

by:nizsmo
ID: 20400558
<?php phpinfo(); ?>

see if you have the oci function enabled properly, you can use the above function which wil output everything.

Let me know how you go.
0
 
LVL 3

Expert Comment

by:yjwong
ID: 20404661
Hi,

Do you have the php_oci8.dll extension enabled in your PHP configuration file (php.ini)? Also check whether php_oci8.dll exists in your extension_dir, and is readable by Apache.

Alternatively, you can rename your oci8.dll to  oci.dll. This way PHP can look for the DLL. Also, you might want to use the client libraries provided with your Oracle installation. To do this, add the ORACLE_PATH\bin directory to your system's %PATH% variable. Also make sure that the path you added must come before any other path containing oci.dll.
0
 
LVL 1

Author Comment

by:chipbunker
ID: 20405129
thanks for the replies.
I am using IIS not apache.

Nizsmo - oci is not enabled the module does not load because of the error
phpinfo does not show it.

vjwong - the extension is enabled the extensions path is set to c:\php\extensions (the location)
I copied the oci.dll from the oracle/bin directory to the extensions directory and enabled it. It also did not work.


0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 3

Expert Comment

by:yjwong
ID: 20405163
Okay, sorry, I thought you were using Apache.

Copy the oci.dll to the PHP directory (the one containing all the executables and php.ini), not the extensions directory. Try that and see whether it will work.
0
 
LVL 1

Author Comment

by:chipbunker
ID: 20405476
ok
I got the module to load, it shows up in php-m from the command line as oci8. but it does not show up in phpinfo()

when I test from my php code I get the error:

FATAL ERROR call to undefined function OCIogon.


0
 
LVL 21

Expert Comment

by:nizsmo
ID: 20405521
Have you also added into the system PATH variable your extension directory?
If it doesn't show up in phpinfo() it means that the extension is not enabled properly.
0
 
LVL 3

Accepted Solution

by:
yjwong earned 750 total points
ID: 20405574
Are you editing the right configuration file? Because the one you edited might be only for the CLI build of PHP. In phpinfo(), check the configuration file path to see whether the one you edited is correct. I'm not sure why this happens though. Have you restarted your web server?
0
 
LVL 1

Author Comment

by:chipbunker
ID: 20405625
I am editing the correct php.ini file. when I make changes they reflect correctly. I usually have to restart the IIS admin service to reload the INI file after changes to reflect them in phpinfo().  

I will try the path change next
0
 
LVL 1

Author Comment

by:chipbunker
ID: 20405737
ok,
The problem was the oci.dll
On my server I have 2 versions of Oracle loaded 9 and 10.  the oci8.dll needs the one from the 9i oracle/bin directory. not the 10.2/bin directory.

thanks
0
 
LVL 1

Author Comment

by:chipbunker
ID: 20405739
vjwong gets the points for his efforts.
0
 
LVL 1

Author Closing Comment

by:chipbunker
ID: 31412496
sometimes you need a push in the right direction, thanks
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many old projects have bad code, but the budget doesn't exist to rewrite the codebase. You can update this code to be safer by introducing contemporary input validation, sanitation, and safer database queries.
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question