Any luck with oracle

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
brett_conklin
Forum Newbie
Posts: 5
Joined: Thu May 23, 2002 2:12 pm

Any luck with oracle

Post 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
User avatar
enygma
Site Admin
Posts: 175
Joined: Fri Apr 19, 2002 8:29 am
Location: Dallas, Tx

Post 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...
brett_conklin
Forum Newbie
Posts: 5
Joined: Thu May 23, 2002 2:12 pm

Post by brett_conklin »

Unix. Solaris. Good news. Any Ideas?
User avatar
enygma
Site Admin
Posts: 175
Joined: Fri Apr 19, 2002 8:29 am
Location: Dallas, Tx

Post 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....
brett_conklin
Forum Newbie
Posts: 5
Joined: Thu May 23, 2002 2:12 pm

Post 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?
brett_conklin
Forum Newbie
Posts: 5
Joined: Thu May 23, 2002 2:12 pm

Post 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
User avatar
enygma
Site Admin
Posts: 175
Joined: Fri Apr 19, 2002 8:29 am
Location: Dallas, Tx

Post 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...
brett_conklin
Forum Newbie
Posts: 5
Joined: Thu May 23, 2002 2:12 pm

Post 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
Post Reply