off-topic: (sorta) freebsd -> oracle, lightweight

At 03:43 PM 10/2/00 -0400, Jim Mercer wrote:

i need to query some oracle tables from a freebsd system.

is there a lightweight method to do this, or do i have no choice but to
put in the Oracle Linux stuff and use their API's?

Oracle knows ODBC, no?

- Don Baccus, Portland OR <dhogaza@pacifier.com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.

I think it's against the Oracle license to run it under any kind of
emulation (which is what you would have to do with FreeBSD, run it under
Linux emulation).. All that's void if they support FreeBSD natively now
(which I don't think they do)..

Wouldn't this be a better question for an Oracle list since this has nothing
to do with PostgreSQL? (Just a friendly suggestion) :-)

Good luck!!

-Mitch

----- Original Message -----
From: "Jim Mercer" <jim@reptiles.org>
To: <hackers@postgresql.org>
Sent: Monday, October 02, 2000 12:43 PM
Subject: [HACKERS] off-topic: (sorta) freebsd -> oracle, lightweight

i need to query some oracle tables from a freebsd system.

is there a lightweight method to do this, or do i have no choice but to
put in the Oracle Linux stuff and use their API's?

--
[ Jim Mercer jim@reptiles.org +1 416

410-5633 ]

[ Reptilian Research -- Longer Life through Colder

]

[ Don't be fooled by cheap Finnish imitations; BSD is the One True

ode. ]

I have absolutely no idea how well it works, but I think Perl/DBI has a
"pass thru" module that can do this sort of thing...

not sure if that helps much...

-philip

On Mon, 2 Oct 2000, Jim Mercer wrote:

The linux version of Oracle works pretty good on FreeBSD (not suggested
if it's going to be a heavy hit database box), then again, I don't
suggest the Linux version of Oracle for that anyway.

Linux compat from -stable is required.

Send your emails off to Oracle requesting the FreeBSD native version (I
understand theres one in creation) and in a few months (year?) we'll all
be happy. Problem (or solution) is that by that time Postgres will fill
all my requirements so I probably wouldn't switch until load or brand
name becomes a serious concern.

Fabrice Scemama wrote:

He can use DBD::Proxy over DBI as he can use ODBC through
network; but at the end, he still has to have a box where
he can install oracle drivers (which are binaries, and
requier you to launch oracle java installer, as if you
were going to install the whole beast, then to choose
to only install a client machine).

Well, Jim, you've got plenty of choices: NT, Linux,
Solaris, AIX, Sco... maybe a few others. But the only
free OS seems to be Linux. Maybe you should take a
cheap intel PC and install linux + oracle client library
on it.

Regards
Fabrice Scemama

Philip Hallstrom wrote:

I have absolutely no idea how well it works, but I think Perl/DBI has a
"pass thru" module that can do this sort of thing...

not sure if that helps much...

-philip

On Mon, 2 Oct 2000, Jim Mercer wrote:

i need to query some oracle tables from a freebsd system.

is there a lightweight method to do this, or do i have no choice but to
put in the Oracle Linux stuff and use their API's?

--
[ Jim Mercer jim@reptiles.org +1 416 410-5633 ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]

--
"La veritable et sincere amitie' verbale profondement superficielle
est celle sur laquelle on peut absolument compter quand on n'a
strictement besoin de rien." -- Pierre Dac

--
Rod Taylor

"People get annoyed when you try to debug them." -- Larry Wall, 2nd
State of the Onion.

"A + B + C = Success if, A = Hard Work, B = Hard Play, C = Keeping your
mouth shut." -- Albert Einstein

--

He can use DBD::Proxy over DBI as he can use ODBC through
network; but at the end, he still has to have a box where
he can install oracle drivers (which are binaries, and
requier you to launch oracle java installer, as if you
were going to install the whole beast, then to choose
to only install a client machine).

Well, Jim, you've got plenty of choices: NT, Linux,
Solaris, AIX, Sco... maybe a few others. But the only
free OS seems to be Linux. Maybe you should take a
cheap intel PC and install linux + oracle client library
on it.

Regards
Fabrice Scemama

Philip Hallstrom wrote:

I have absolutely no idea how well it works, but I think Perl/DBI has a
"pass thru" module that can do this sort of thing...

not sure if that helps much...

-philip

On Mon, 2 Oct 2000, Jim Mercer wrote:

i need to query some oracle tables from a freebsd system.

is there a lightweight method to do this, or do i have no choice but to
put in the Oracle Linux stuff and use their API's?

--
[ Jim Mercer jim@reptiles.org +1 416 410-5633 ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]

--
"La veritable et sincere amitie' verbale profondement superficielle
est celle sur laquelle on peut absolument compter quand on n'a
strictement besoin de rien." -- Pierre Dac