From owner-freebsd-questions@FreeBSD.ORG Tue Apr 15 10:29:44 2003 Return-Path: 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 40A0937B404 for ; Tue, 15 Apr 2003 10:29:44 -0700 (PDT) Received: from mired.org (ip68-97-54-220.ok.ok.cox.net [68.97.54.220]) by mx1.FreeBSD.org (Postfix) with SMTP id 4220D43F85 for ; Tue, 15 Apr 2003 10:29:43 -0700 (PDT) (envelope-from mwm-dated-1050859782.b22834@mired.org) Received: (qmail 69318 invoked from network); 15 Apr 2003 17:29:42 -0000 Received: from localhost.mired.org (HELO guru.mired.org) (127.0.0.1) by localhost.mired.org with SMTP; 15 Apr 2003 17:29:42 -0000 Received: by guru.mired.org (tmda-inject, from uid 100); Tue, 15 Apr 2003 12:29:42 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <16028.16773.558500.874498@guru.mired.org> Date: Tue, 15 Apr 2003 12:29:41 -0500 To: Lorin Lund In-Reply-To: <3E9C33A5.7060202@infowest.com> References: <3E9C33A5.7060202@infowest.com> X-Mailer: VM 7.07 under 21.1 (patch 14) "Cuyahoga Valley" XEmacs Lucid X-face: "5Mnwy%?j>IIV\)A=):rjWL~NB2aH[}Yq8Z=u~vJ`"(,&SiLvbbz2W`; h9L,Yg`+vb1>RG% *h+%X^n0EZd>TM8_IB;a8F?(Fb"lw'IgCoyM.[Lg#r\ From: Mike Meyer X-Delivery-Agent: TMDA/0.74 (Citation) cc: freebsd-questions@freebsd.org Subject: Re: ODBC access under Linux compatibility X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 15 Apr 2003 17:29:44 -0000 In <3E9C33A5.7060202@infowest.com>, Lorin Lund typed: > I am using an interpreted language whose interpreter is built for Linux. > So I am relying on > Linux compatibility. I have built and installed > /usr/ports/databases/libiodbc. Calls to the > library fail. It just occurred to me that libiodbc.so is a FreeBSD > format library and the > program that is trying to access it is a Linux format binary. > > How can I get Linux compatible ODBC service running? You need to install a linux ODBC driver manager and drivers. I'd check for rpms for the iodbc on the popular linux sites. > At this time I don't need native FreeBSD ODBC access and Linux > compatible access > concurrently, but what if I did? You'd have to install ODBC driver managers and drivers for both linux and FreeBSD. The drivers and libraries for linux should install in /usr/compat/linux/..., and the ones for FreeBSD in /usr/local/..., so that's not a problem. You'd probably have to arrange for them to use different config files, which may be interesting. Two alternative solutions to your current problem, both of which depend on the interpreter you are using: 1) Try to get the interpreter built for FreeBSD. If it's open source, it may be easy to port, or already available via the ports tree. 2) Skip using odbc, and try connecting directly to the data source. That will also improve the performance of your applications. http://www.mired.org/consulting.html Independent Network/Unix/Perforce consultant, email for more information.