Page 1 of 1

Any luck with oracle

Posted: Thu May 23, 2002 2:12 pm
by brett_conklin
I noticed that most posting are in reagrds to Mysql. Rightfully so. But I am trying to connect to oracle. I undersand that I need to get the oracle module. I have two questions first, where do I find the oracle module, Second, once I have it how do I install.
Thanks
Brett

Posted: Thu May 23, 2002 4:20 pm
by enygma
Windows or Unix-based?
I'm assuming Windows, since you're talking about the module and not the libraries...

I think all you need to do is uncomment that dll in the php.ini and put it with the rest of them.

I believe that's all it takes to get it to work...

Posted: Thu May 23, 2002 4:21 pm
by brett_conklin
Unix. Solaris. Good news. Any Ideas?

Posted: Thu May 23, 2002 4:40 pm
by enygma
so, you do have the Oracle libraries (from an Oracle client install) on the same machine?

If not, you'll need to get that installed before you can compile with the oracle stuff....

Posted: Thu May 23, 2002 4:46 pm
by brett_conklin
Thanks for the reply

"so, you do have the Oracle libraries (from an Oracle client install) on the same machine? "

Yes the oracle client is installed. Sqlplus is working.


"If not, you'll need to get that installed before you can compile with the oracle stuff...."

How do I get the libs?

Posted: Thu May 23, 2002 4:48 pm
by brett_conklin
Or better yet how do I use them? via configure? in the php directory?

I am currently trying
http://www.phpbuilder.com/columns/yenigul20020122.php3

Posted: Thu May 23, 2002 4:58 pm
by enygma
yup - you have to configure PHP to use the oracle stuff using:

--with-oci8=/u01/app/oracle/product/8.1.6 (path to libraries)

and/or

--with-oracle=/u01/app/oracle/product/8.1.6 (path to libs)

in your PHP configure statement along with the other features you want added in...

Posted: Thu May 23, 2002 6:44 pm
by brett_conklin
come to find out we did not have our DSO compiled into apache. So after an apache recompile we can recompile PHP with the oracle libs.

Ill let you know the progress. THanks for the help.

Brett