From owner-freebsd-questions Mon Aug 4 15:59:16 1997 Return-Path: Received: (from root@localhost) by hub.freebsd.org (8.8.5/8.8.5) id PAA03765 for questions-outgoing; Mon, 4 Aug 1997 15:59:16 -0700 (PDT) Received: from Kitten.mcs.com (Kitten.mcs.com [192.160.127.90]) by hub.freebsd.org (8.8.5/8.8.5) with ESMTP id PAA03758 for ; Mon, 4 Aug 1997 15:59:14 -0700 (PDT) Received: from Jupiter.Mcs.Net (font@Jupiter.mcs.net [192.160.127.88]) by Kitten.mcs.com (8.8.5/8.8.2) with ESMTP id RAA15230; Mon, 4 Aug 1997 17:59:12 -0500 (CDT) Received: from localhost (font@localhost) by Jupiter.Mcs.Net (8.8.5/8.8.2) with SMTP id RAA01717; Mon, 4 Aug 1997 17:59:12 -0500 (CDT) Date: Mon, 4 Aug 1997 17:59:12 -0500 (CDT) From: Font To: Cliff Addy cc: questions@FreeBSD.ORG Subject: Re: ODBC In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@FreeBSD.ORG X-Loop: FreeBSD.org Precedence: bulk I have done something like this by writing a short glue program which accepts and translates SQL queries and results on the NT Server side. It is written using MS VC++ (yuck). On the FreeBSD side, where my web server is, a small library interfaces with the glue program and allows a C CGI program to get the appropriate database results. I couldn't really find any ODBC software under FreeBSD with source code which I could modify, so I cobbled together this solution instead. To keep things on the Windows side simple, I used an InetD clone from a company called InterAccess/PragmaSys so I could write the ODBC glue using stdio. Otherwise it was just VC++ 2.0 and ODBC SDK 3.0. Basically it ends up being that the NT side has a telnet-able SQL query handler. If you find any better solutions that don't involve programming on NT, please share 'em with the list. I would like a pure FreeBSD solution as well. -- A bug in my MUA causes news.announce.newusers font to be sent to beneficiaries and senders of UCE/SPAM. @ mcs.net Wishes are like dishes. On Mon, 4 Aug 1997, Cliff Addy wrote: > Date: Mon, 4 Aug 1997 16:00:28 -0400 (EDT) > From: Cliff Addy > To: questions@FreeBSD.ORG > Subject: ODBC > > Is there a perl library that lets a script talk to an ODBC-compliant > database server on another box? > > What we need to do is have clients be able to upload their MS Access or > whatever databases and then query them from a web server CGI script. We > have one WindowsNT server that could host something like SQL server > talking ODBC. Then the cgi script over on the FBSD box would connect to > the SQL server and get the results. > > Any ideas? >