Return to BSD News archive
Path: euryale.cc.adfa.oz.au!newshost.carno.net.au!harbinger.cc.monash.edu.au!news.telstra.net!vic.news.telstra.net!sleipnir.iaccess.com.au!news.unimelb.EDU.AU!munnari.OZ.AU!news.ecn.uoknor.edu!feed1.news.erols.com!cpk-news-hub1.bbnplanet.com!cpk-news-feed2.bbnplanet.com!cam-news-hub1.bbnplanet.com!news.bbnplanet.com!howland.erols.net!rill.news.pipex.net!pipex!uunet!in1.uu.net!204.179.98.2!news.visigenic.com!news From: Tim O'Neil <toneil@visigenic.com> Newsgroups: comp.unix.bsd.freebsd.misc Subject: Re: MS SQL Server access from FreeBSD? Date: Thu, 13 Feb 1997 12:27:42 +0000 Organization: Visigenic Software, Inc. Lines: 28 Message-ID: <330308BE.5866@visigenic.com> References: <5dggtd$dpi$1@Venus.mcs.net> <5dvgf9$h1t$1@news.ziplink.net> Reply-To: toneil@visigenic.com NNTP-Posting-Host: vsi48.visigenic.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 3.0 (WinNT; U) Xref: euryale.cc.adfa.oz.au comp.unix.bsd.freebsd.misc:35558 Mikhail Teterin wrote: > > Honorable Font > wrote on 08 Feb (in article <5dggtd$dpi$1@venus.mcs.net>): > > =Now, what I'd like to do is access the databases from a FreeBSD box, > =presumably using ODBC via TCP/IP. This will help me continue to use > =Apache as a web server and have a nice database back end. > > I'd say you do not need NT's SQL at all. There are a few very nice > SQL-engines for FreeBSD itself (look at /usr/ports/databases) with > API for many languages (C, TCL, Perl, others). > > Remember, that all Microsoft beasts only work well on demos and > samples... > > BTW, does anyone know if MSQL or Postgres95 have ODBC support? Yes, mSQL does. But I only have first hand knowlege of the 32 bit windows driver. This particular driver needs a lot of work. Love the dbms though. I don't know ports of the driver. As for MS SQL Server, lemme add my two cents. I use MS SQL Server 6.0 and 6.5 regularly (I'm an odbc driver support engineer). Frankly, MS SQL Server (6.5 especially) is a fine product. We make an odbc driver for it for solaris. I'd normally prefer my back end on a unix box, but SQL Server has a lot of nice features and is consistantly faster accross the wire than some of the others we deal with.