KaHeL
KaHeL

Reputation: 4371

How to connect PHP to Oracle9i server

I read some steps about this one but I can't really get it. I'm using wamp server for this with PHP 5.3.5. I tried to use the php_oci8.dll by checking the PHP>PHP extensions>php_oci8 but I get an error saying

PHP Startup: Unable to load dynamic library 'c:/wamp/bin/php/php5.3.5/ext/php_oci8.dll - The specified module could not be found

When I go to the path the php_oci8.dll is there. How can I fix this? Can anybody give me a steps on how can I configure it so that I can connect to a remote server?

Upvotes: 2

Views: 1978

Answers (2)

KaHeL
KaHeL

Reputation: 4371

I already figured it out! Here's my solution:

  1. Install Oracle XE in your PC this will give you the latest oci.dll (not php_oci8.dll)
  2. Create a link between your user and the user you will need in connecting to your database.
  3. Restart your PC then try running your code if it's not working copy the oci.dll of your Oracle XE (C:\Oracle\OUIHome\bin\oci.dll) then paste it in 9i replacing the old one (make sure to have a backup). then restart your PC.

Works fine on me. Thanks for those who help me in solving this one.

Upvotes: 0

powtac
powtac

Reputation: 41040

Try to download the latest version of the dll here php_oci8-1.4.1-5.2-vc6-x86.zip

Upvotes: 1

Related Questions