From owner-freebsd-questions@FreeBSD.ORG  Fri Mar  5 14:39:15 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 2C7A916A4CE
	for <freebsd-questions@freebsd.org>;
	Fri,  5 Mar 2004 14:39:15 -0800 (PST)
Received: from dc.cis.okstate.edu (dc.cis.okstate.edu [139.78.100.219])
	by mx1.FreeBSD.org (Postfix) with ESMTP id F0FE443D2F
	for <freebsd-questions@freebsd.org>;
	Fri,  5 Mar 2004 14:39:14 -0800 (PST)
	(envelope-from martin@dc.cis.okstate.edu)
Received: from dc.cis.okstate.edu (localhost.cis.okstate.edu [127.0.0.1])
	by dc.cis.okstate.edu (8.12.6/8.12.6) with ESMTP id i25MdEOf084570
	for <freebsd-questions@freebsd.org>;
	Fri, 5 Mar 2004 16:39:14 -0600 (CST)
	(envelope-from martin@dc.cis.okstate.edu)
Message-Id: <200403052239.i25MdEOf084570@dc.cis.okstate.edu>
To: freebsd-questions@freebsd.org
Date: Fri, 05 Mar 2004 16:39:14 -0600
From: Martin McCormick <martin@dc.cis.okstate.edu>
Subject: Accessing Oracle8i Data on a FreeBSD System
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 05 Mar 2004 22:39:15 -0000

I have just been thrust in to unknown waters when it comes to
data bases.  I will be writing scripts which live on a FreeBSD Unix
system and which will query a Pinnacle server on another host.

	The only oracle client for FreeBSD is oracle7-client.  There
is also oracle7 support in the current port of php, but nothing that
says oracle8I.

	There is a linux distribution available on the Oracle web
site called linux81701.tar, but it appears to be for those wishing to
run an oracle8I server.

	What we are trying to do is:
Receive data from the oracle data base on the Pinnacle server, process
the data, and be able to set or clear flags on data we send back to
the Pinnacle server.

	My question is what tools do I actually need under FreeBSD
Unix to access the Pinnacle server's oracle8i data?

	We presently use freetds to do exactly this sort of thing with
data in a MSsql data base on yet a different platform.

	The only thing I am bewildered about right now is how to or
maybe whether it is possible to access the oracle8I DB?

	Many thanks to all.

Martin McCormick WB5AGZ  Stillwater, OK 
OSU Information Technology Division Network Operations Group