From owner-freebsd-questions@FreeBSD.ORG Mon Dec 4 22:16:03 2006 Return-Path: X-Original-To: questions@freebsd.org Delivered-To: freebsd-questions@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id D2E9316A407 for ; Mon, 4 Dec 2006 22:16:03 +0000 (UTC) (envelope-from mcgovern@spoon.beta.com) Received: from spoon.beta.com (spoon.beta.com [199.165.180.1]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3DB0143DA1 for ; Mon, 4 Dec 2006 22:14:21 +0000 (GMT) (envelope-from mcgovern@spoon.beta.com) Received: from spoon.beta.com (localhost [127.0.0.1]) by spoon.beta.com (8.13.4/8.13.4) with ESMTP id kB4MEhmD047158 for ; Mon, 4 Dec 2006 17:14:43 -0500 (EST) (envelope-from mcgovern@spoon.beta.com) Message-Id: <200612042214.kB4MEhmD047158@spoon.beta.com> To: questions@freebsd.org Date: Mon, 04 Dec 2006 17:14:43 -0500 From: "Brian J. McGovern" X-Spam-Status: No, score=-1.4 required=5.0 tests=ALL_TRUSTED autolearn=failed version=3.1.0 X-Spam-Checker-Version: SpamAssassin 3.1.0 (2005-09-13) on spoon.beta.com Cc: Subject: Looking for a cookbook on Oracle clients... 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: Mon, 04 Dec 2006 22:16:03 -0000 All, I have a task that requires I extract a data set from a MySQL server, and push it on to an Oracle (9i) server. I figured I'd go the ODBC route, and installed unix_odbc_driver and its dependencies. However, its pretty clear that I don't fully understand what I'm doing, and each step forward is costing me half a day of debugging, reading code, and banging my head against the wall. From the documents I can find on the web, it seems all I should have to do is install, configure my odbc.ini and odbcinst.ini files, and go. So, the questions: 1.) Is anyone using unixODBC and oracle_driver_odbc against a 9i server? 2.) If so, can someone send me their .ini files and any other environment and oracle settings they needed to do to make it work (mine are below)? 3.) Have people moved over to the instantclient in ports? If so, does anyone have some sample code to test the basic ability to connect? -Brian [Oracle] Description = Oracle Configuration Driver = Oracle Trace = Yes TraceFile = /var/log/odbc.log Database = eengstg Servername = oracle_server UserName = XXXXXXXX Password = XXXXXXXX Port = 1521 [Oracle] Description = Oracle driver for FreeBSD Driver = /usr/local/lib/liboraodbc.so Setup = /usr/local/lib/liboradbS.so