Oracle DBD (or how to connect to Oracle Database)
Dave Hummel
I'm sure this problem is shared by many: We want to run more (all?) of our
webservers on FreeBSD but we _must_ be able to connect to an Oracle
Database (on Solaris) with mod_perl. Has anyone been able to get DBD::Ora
going? The best solution would be DBD::Ora compiled/distributed in such a
way that the webserver need not have Oracle installed on it. I intend to
pursue this, but I'm wondering if someone more clever than me has done it
already.
Or is there another solution entirely?
Ideas anyone?
Thanks,
Dave
p.s. - <rant> The fact that Oracle doesn't support FreeBSD is reason
enough in my eyes to refrain from using their product (c'mon, at least
make client libs available). I feel like I should support opensource and
FreeBSD-friendly companies like MySQL, but this does me no good for sites
currently running Oracle.</rant>
To Unsubscribe: send mail to majo...@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message
Ray Stell
http://www.scc.nl/~marcel/howto-oracle.html
was my starting place, though there were many a twist along
the way. I am trying to repeat under 3.3
===============================================================
Ray Stell ste...@vt.edu (540) 231-4109 KE4TJC 28^D
Joseph Scott
Giorgos Keramidas wrote:
>
> Dave Hummel <dhu...@ppgweb.com> writes:
>
> [snip]
>
> > Or is there another solution entirely?
>
> home page at <http://www.php.net/> should provide you with all the information
> you need. I think that using PHP with Oracle is a lot easier, but this is my
> own personal opinion... and I am not trying to force anyone to agree with me.
I don't think either of them will work, they require the Oracle Client
libs, which is the problem I believe. Because they are for Linux they
won't compile with FreeBSD version of PHP or the DBD/DBI::ORA stuff. If
I'm wrong I would love for someone to point out how to make PHP3 link
against the Oracle Client libs for Oracle support under FreeBSD. I
tried this many, many, many times and didn't have any luck. Then again
there may be someone out there with more diligence and intelligence than
I who has made it work
--
Joseph Scott
joseph...@owp.csus.edu
Office Of Water Programs - CSU Sacramento
Giorgos Keramidas
> Giorgos Keramidas wrote:
>
> If I'm wrong I would love for someone to point out how to make PHP3 link
> against the Oracle Client libs for Oracle support under FreeBSD.
You are not wrong, not at all. However, PHP works with ODBC and Oracle can be
user over ODBC too. The problem is that doing all this extra work, installing
ODBC libraries, PHP, configuring Apache, etc. might be a little overkill
compared to what one can do with the Oracle client libs. Therefore, you are
right at this point.
--
Giorgos Keramidas, <kera...@ceid.upatras.gr>
"What we have to learn to do, we learn by doing." [Aristotle]
Joseph Scott
Giorgos Keramidas wrote:
>
> Joseph Scott <joseph...@owp.csus.edu> writes:
>
> > Giorgos Keramidas wrote:
> >
> > If I'm wrong I would love for someone to point out how to make PHP3 link
> > against the Oracle Client libs for Oracle support under FreeBSD.
>
> You are not wrong, not at all. However, PHP works with ODBC and Oracle can be
> user over ODBC too. The problem is that doing all this extra work, installing
> ODBC libraries, PHP, configuring Apache, etc. might be a little overkill
> compared to what one can do with the Oracle client libs. Therefore, you are
> right at this point.
What ODBC are did you use under FreeBSD? I remember coming across a
couple of them, I think there was iODBC, then there was also something
called FreeTDS or some such.
--
Joseph Scott
joseph...@owp.csus.edu
Office Of Water Programs - CSU Sacramento
Giorgos Keramidas
[snip]
> Or is there another solution entirely?
If you're not completely stuck on DB::Ora, you could try using PHP. Their
home page at <http://www.php.net/> should provide you with all the information
you need. I think that using PHP with Oracle is a lot easier, but this is my
own personal opinion... and I am not trying to force anyone to agree with me.
--
Giorgos Keramidas, <kera...@ceid.upatras.gr>
"What we have to learn to do, we learn by doing." [Aristotle]