From owner-freebsd-questions@FreeBSD.ORG Tue May 6 13:45:09 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 4E80237B401 for ; Tue, 6 May 2003 13:45:09 -0700 (PDT) Received: from lakemtao04.cox.net (lakemtao04.cox.net [68.1.17.241]) by mx1.FreeBSD.org (Postfix) with ESMTP id 53D9843FAF for ; Tue, 6 May 2003 13:45:08 -0700 (PDT) (envelope-from tcornpropst@cox.net) Received: from beastie.cornpropst.net ([68.100.175.64]) by lakemtao04.cox.netESMTP <20030506204508.WXLH13930.lakemtao04.cox.net@beastie.cornpropst.net>; Tue, 6 May 2003 16:45:08 -0400 From: "Trevor S. Cornpropst" To: Lorin Lund , freebsd-questions@freebsd.org Date: Tue, 6 May 2003 16:45:07 -0400 User-Agent: KMail/1.5 References: <20030506190626.17970.qmail@web41506.mail.yahoo.com> In-Reply-To: <20030506190626.17970.qmail@web41506.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200305061645.07254.tcornpropst@cox.net> Subject: Re: libiodbc configuration X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: tcornpropst@acm.org List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 06 May 2003 20:45:09 -0000 On Tuesday 06 May 2003 15:06, Lorin Lund wrote: > I have MySQL installed on my 4.8 system. > > Libiodbc got installed by installing mSQL,MySQL > modules for perl. > > Perl access to MySQL worked OK. So I supposed the > iODBC was fully configured. When I tried ODBC > from another language it didn't work. > > When I tried the test program 'odbctest' it lists > the field names from .odbc.ini as if they were > DSNs. When I access odbc from the language 'J' > and ask for a list of data sources I get the same > list as shows up in 'odbctest'. > > I certainly have something messed up! > > (When I couldn't get things to work with iODBC I tried > installing unixODBC - maybe that messed things up.) > > Does anyone recognize these symptoms? Lorin, I think you may have some misunderstandings here, I'll see if I can help. I am not familiar with 'J' but I don't think that is at issue here. ODBC is not needed to connect to MySQL and msql using perl from a FreeBSD machine. Perl uses DBD (Database Dependent) drivers to access these databases. However, you may still use ODBC if you wish but, why would you? MySQL can use myodbc to use ODBC for database connectivity and it depends on either unixodbc or libiodbc. libiodbc was likely installed because you installed /usr/ports/databases/p5-DBD-ODBC. libiodbc only provides an ODBC "driver manager". You still need to install an ODBC driver for the database you wish to connect to. You can find FreeBSD ODBC drivers from www.openlinksw.com that work with libiodbc or use their driver manager which is the same thing. They released libiodbc (www.iodbc.org) as an open source version of their ODBC driver manager. It sounds like 'J' is properly configured to use ODBC if you get the same list of DSN's within J as you do with odbctest. So: 1. Have you installed an ODBC database driver for the database you are connecting to? 2. Have you configured a DSN in your .odbc.ini and .odbcinst.ini to use that driver with the database? 3. What, specifically, are you trying to do? Trevor Cornpropst