From owner-freebsd-database Fri Nov 17 20: 2:18 2000 Delivered-To: freebsd-database@freebsd.org Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (Postfix) with ESMTP id EA86D37B479 for ; Fri, 17 Nov 2000 20:02:14 -0800 (PST) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 13wynQ-0004aO-00; Fri, 17 Nov 2000 19:36:08 -0800 Date: Fri, 17 Nov 2000 19:35:57 -0800 (PST) From: Tom Samplonius To: Calvin Cc: freebsd-database@FreeBSD.ORG, posonsky@braz.ru Subject: Re: How to run OCI FreeBSD Program to access Oracle database? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Fri, 17 Nov 2000, Calvin wrote: > Hello all, > > We are running Oracle database 8.1.6.2.1 in Sun Solaris and C programs at > FreeBSD platform need to access the database thru OCI. We knew from Oracle > Support that we have to install Oracle client software with libs in the > client side in order to have C programs connect to the database using OCI. > However, Oracle doesn't support FreeBSD platform. Is there anyone running > OCI freebsd program to access db, or anyone setup the Oracle client software > 8.1.6 in FreeBSD 4.02-Stable? There are a few options and none of them is very appealing: - Use the Linux OCI driver and compile all your applications are Linux binaries and run them on FreeBSD under emulation. - Use the request broker from Openlink Software (http://www.opelinksw.com). It should be free for up to two connections. Basically, your FreeBSD application must be able to support ODBC. Openlink providers a ODBC driver for FreeBSD and a request broker that can be run on your database server (or anywhere else that a native Oracle interface is available). The Openlink ODBC driver will connect to the request broker, and the broker to Oracle. This will not work if your app does not use an ODBC interface and requires the propietary Oracle OCI API. - Re-write your app in Java. Type 4 JDBC drivers are truly OS independant and work on any system with a JVM. > Thanks, > Calvin Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message