From owner-freebsd-questions@FreeBSD.ORG Tue Jun 2 23:06:49 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id E0BA81065687 for ; Tue, 2 Jun 2009 23:06:49 +0000 (UTC) (envelope-from mikes@siralan.org) Received: from arvo.suso.org (arvo.suso.org [66.244.94.5]) by mx1.freebsd.org (Postfix) with ESMTP id BCD318FC13 for ; Tue, 2 Jun 2009 23:06:49 +0000 (UTC) (envelope-from mikes@siralan.org) Received: from c-98-220-3-224.hsd1.in.comcast.net (c-98-220-3-224.hsd1.in.comcast.net [98.220.3.224]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by arvo.suso.org (Postfix) with ESMTP id A8D0D88057; Tue, 2 Jun 2009 22:40:23 +0000 (GMT) Date: Tue, 2 Jun 2009 18:41:16 -0400 (EDT) From: "Michael L. Squires" X-X-Sender: mikes@familysquires.net To: Gary Gatten In-Reply-To: <70C0964126D66F458E688618E1CD008A0793EE7D@WADPEXV0.waddell.com> Message-ID: <20090602182901.Y16783@familysquires.net> References: <200906022159.n52LxQlS089946@dc.cis.okstate.edu> <70C0964126D66F458E688618E1CD008A0793EE7D@WADPEXV0.waddell.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: Martin McCormick , freebsd-questions@freebsd.org Subject: RE: Can One Query an Oracle 10 Data Base under FreeBSD? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 02 Jun 2009 23:06:50 -0000 On Tue, 2 Jun 2009, Gary Gatten wrote: > Surely there's a native Oracle SQL or ODBC client in the ports > collection. Have you checked there? > > -----Original Message----- > From: owner-freebsd-questions@freebsd.org > [mailto:owner-freebsd-questions@freebsd.org] On Behalf Of Martin > McCormick > Sent: Tuesday, June 02, 2009 4:59 PM > To: freebsd-questions@freebsd.org > Subject: Can One Query an Oracle 10 Data Base under FreeBSD? > > The Subject is most of the question. We will need to query an > Oracle 10 data base and manipulate data. Is this presently > possible under FreeBSD? > > Thank you. > > > Martin McCormick WB5AGZ Stillwater, OK > Systems Engineer > OSU Information Technology Department Telecommunications Services Group There is a port of the Oracle instant client which runs under Linux emulation in /usr/ports/databases/linux-oracle-instantclient- This appears to use the 10.2.0.3 Oracle Linux instant client. I used them some time ago to query an Oracle 10g server, but I didn't test them extensively. There are also what appear to be older native clients from the Oracle 7 and 8 days, including an Oracle ODBC client. A search of the freebsd-databases mailing list might turn up something. I've been peeking at Talend's Open Studio which appears to be a very powerful tool for working with databases, including Oracle. This may be trying to shoot a mouse with a 155mm self-propelled gun, however. Talend is open source and there are Linux binaries which may run under FreeBSD Linux emulation. Mike Squires