|
|
Posted by Andy Hassall on 02/07/06 02:45
On 6 Feb 2006 15:15:23 -0800, "DravenStone" <chiptricks@gmail.com> wrote:
>I had just a horrible day at work, spent pretty much the entire day
>trying to get php_oci.dll
What is php_oci.dll? Do you mean php_oci8.dll?
> and php_oracle.dll to load.
Forget php_oracle.dll, that's for Oracle 7.
>Make ONE call on ONE page to a legacy oracle database we have (8)...
>Works FINE on my machine.
>
>Ported everything to the server. NO DICE enabling php_oci8.dll and
>php_oracle.dll
>PHP is 5.5.1.
What version is it really?
Not that it should actually make any difference in terms of getting it going
in the first place, but 5.1.2 comes with a considerably updated version of the
OCI8 extension with lots of bug fixes and some new features (persistent
connection pinging and timeouts, for example).
>DL'ed instant client. Pulled the three dll's I am supposed to out, put
>them in C:\instantclient
Unpack all of the instant client zip rather than picking and choosing, unless
you really know what you're doing.
>Added C:\instantclient to class path:
Class path is Java, do you mean PATH?
>Error loading dll, procedure not found (note: not module... It's
>finding the oci and oracle dll in the /ext directory)...
Which of the two PHP extensions were you trying to load at this point?
>I think it's more an oracle driver/dll/something I can't figure out
>problem.
>I've spent a whole day googling things, trying to change this classpath
>and that class path, adding something71.dll and somethingelse71.dll
>(forgive me, I'm at home now and can't remember exactly)...
>
>But absolutely nothing worked.
Hacking around isn't going to help and will just get you into more of a mess
since you won't know how to undo it. There's a just a few steps you have to do
to get Oracle PHP support working, but it's not at all forgiving to messing
around. Were you following any particular instructions, such as:
http://www.oracle.com/technology/pub/notes/technote_php_instant.html ?
I see there it mentions unzipping just three of the Instant Client DLLs, well,
I suppose that's on an Oracle site so they should know which ones are needed,
but it makes sense to unpack the lot.
The usual snag I hit on Windows is getting the updated environment variables
into the web server process - remember that if you just restart it, it may not
see the new environment. If you open a new command window after changing the
environment variable, then use "net stop apache2" and "net start apache2" then
it's more likely to pick up the change. (Or reboot)
The other one is permissions; make sure the web server user has permissions to
access all the libraries and files involved. That's usually an issue with the
full client install that locks down permissions by default, rather than the
instant client.
--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Navigation:
[Reply to this message]
|