*BSD News Article 91325


Return to BSD News archive

Path: euryale.cc.adfa.oz.au!newshost.carno.net.au!harbinger.cc.monash.edu.au!news.mira.net.au!news.netspace.net.au!news.mel.connect.com.au!munnari.OZ.AU!news.ecn.uoknor.edu!news.wildstar.net!serv.hinet.net!news-peer.nctu.edu.tw!news.nctu.edu.tw!spring.edu.tw!howland.erols.net!cam-news-hub1.bbnplanet.com!news.bbnplanet.com!news-xfer.netaxs.com!ddsw1!news.mcs.net!ddsw1!not-for-mail
From: font@MCS.COM (Font)
Newsgroups: comp.unix.bsd.freebsd.misc
Subject: Re: ODBC & freeBSD
Date: 17 Mar 1997 18:43:15 -0600
Organization: MCSNet Services
Lines: 24
Message-ID: <5gkof3$duf$1@Venus.mcs.net>
References: <332DC321.7932@madisontelco.com>
NNTP-Posting-Host: venus.mcs.net
Xref: euryale.cc.adfa.oz.au comp.unix.bsd.freebsd.misc:37251

Mike Payne <mpayne@madisontelco.com> writes:

>Does anyone know of any ODBC client drivers for freeBSD?  I need to
>access a  Microsoft SQL-Server 6.5 database running on a Windows NT 4.0
>system from a web site running freeBSD.  I found an ODBC client manager,
>but not any drivers.  If there are not any drivers, does anyone know of
>any products that I can purchase that would allow me to access the
>database?

I had to do something similar, ended up finding no appropriate
products, and wrote an ad hoc query/command processor on NT which
delivers everything to the generic FreeBSD box through a socket.  Not
too sophisticated, but it does work.  (Also used Pragma Systems NT
version of inetd so I wouldn't have to write WinSock, blech.)  The
ODBC 3.0 SDK I needed for this was on Microsoft's web site.

It may be possible to replace MS SQL Server with GNU SQL Server in
future, so a glue-like approach of this type may insulate db server
changes which you may desire later.

You have some really odd characters in your post, which you might want
to get fixed...  (Some of your 0x20 spaces are coming out 0xa0.)
-- 
font@mcs.net                              Wishes are like dishes.