|
|
Posted by DravenStone on 02/07/06 04:43
What is php_oci.dll? Do you mean php_oci8.dll?
Of course... sorry, I reference it properly three other times in the
post...
> and php_oracle.dll to load.
Forget php_oracle.dll, that's for Oracle 7.
Agreed...
>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?
5.1.1, which I clarafied in an earlier response, sorry...
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).
Yup, I read all about that today, but I'm not running 5.1.2...
>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.
I've tried that as well... I tried everything I could think of...
>Added C:\instantclient to class path:
Class path is Java, do you mean PATH?
Yes, I mean path. Sorry, like I said, I'm a jack of all trades, master
of none kind of guy and I have done a lot of JSP stuff so I've got java
on the brain... (Plus I wrote this when I got HOME from work and was
already brain fried)...
>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?
oci8 and oracle (both of which I load fine on my other machine)
>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 followed those exactly. Further, I had followed those exactly on my
other machine and it worked in two minutes as it should... hence my
amazingly high level of frustration.
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.
Again, I tried that, no help.
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)
Multiple times I restarted apache using a variety of methods AND
rebooted...
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.
Was logged in as administrator all day, XAMPP was installed as admin as
well.
Navigation:
[Reply to this message]
|