Date: Tue, 6 May 2003 16:45:07 -0400 From: "Trevor S. Cornpropst" <tcornpropst@cox.net> To: Lorin Lund <lorin_lund@yahoo.com>, freebsd-questions@freebsd.org Subject: Re: libiodbc configuration Message-ID: <200305061645.07254.tcornpropst@cox.net> In-Reply-To: <20030506190626.17970.qmail@web41506.mail.yahoo.com> References: <20030506190626.17970.qmail@web41506.mail.yahoo.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200305061645.07254.tcornpropst>