Return to BSD News archive
Path: euryale.cc.adfa.oz.au!newshost.carno.net.au!harbinger.cc.monash.edu.au!lucy.swin.edu.au!news.rmit.EDU.AU!news.unimelb.edu.au!munnari.OZ.AU!news.ecn.uoknor.edu!news.wildstar.net!news.sdsmt.edu!data.ramona.vix.com!news1.digital.com!su-news-hub1.bbnplanet.com!cam-news-feed5.bbnplanet.com!news.bbnplanet.com!papergirl.highway1.com!chnws02.highway1.com!ndnws01.ne.highway1.com.!news From: Ted Buswell <tbuswell@balrog.ml.org> Newsgroups: comp.unix.bsd.freebsd.misc Subject: Re: FreeBSD and ODBC Connectivity Date: 12 Jun 1997 00:40:01 -0400 Organization: nntp Needham Lines: 33 Message-ID: <87lo4ga0ym.fsf@balrog.ml.org> References: <5nm7ma$ls@umbc7.umbc.edu> NNTP-Posting-Host: tbuswell.ne.highway1.com X-Newsreader: Gnus v5.3/Emacs 19.34 Xref: euryale.cc.adfa.oz.au comp.unix.bsd.freebsd.misc:42789 pauld@umbc.edu (Paul Danckaert) writes: > I'm looking for a way of connecting a FreeBSD (or any Unix) machine to an > ODBC database to do standard queries, inserts, etc. What sorts of public > domain or commercial solutions are there? As someone else noted, the solution(s) depends on what database(s) you want to talk to. I haven't looked very closely at it, but there is a free ODBC manager floating around, with which you are then able to implement ODBC drivers (as a library) and have them fit into a "bigger picture". (I think->) A sample implementation of an ODBC driver using this framework is the driver for the MySQL database (never used it). There's also an ODBC driver for NNTP (wow!). You can get the manager and NNTP driver in shar file's at ftp://ftp.uu.net/pub/database/perl-interfaces/other/iODBC/ Since you said "other unix's", you might check out www.openlink.co.uk. You need to fill out a form in order to see what they currently have available, but if I remember correctly, they did have drivers available for several flavors of commercial Unix, but none for any of the free ones. Finding a host-database-driver-openlinkproprietarybackendlayer combination that fits your picture might be a challenge though (was for me). Also, (and I really know nothing about this) on the Solaris CDE CD, it says something about ODBC drivers -- I just noticed that the other day and it raised some interest, but not enough for me to put the CD in the drive or read a manual or anything. Even though it's not what you were asking about, there are a multiple solutions for hosting a (free) database running on FreeBSD (or any Unix) with clients on lesser OS's. As a previous poster said, forget about the O in ODBC. -Ted