From owner-freebsd-questions Sat Oct 5 18:13:38 2002 Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 096B237B401 for ; Sat, 5 Oct 2002 18:13:37 -0700 (PDT) Received: from ns1.webwarrior.net (overlord-host99.dsl.visi.com [209.98.86.99]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0843043E42 for ; Sat, 5 Oct 2002 18:13:36 -0700 (PDT) (envelope-from friar_josh@webwarrior.net) Received: by ns1.webwarrior.net (Postfix, from userid 1003) id 59DEE252FA; Sun, 6 Oct 2002 02:16:11 -0500 (CDT) Date: Sun, 6 Oct 2002 02:16:11 -0500 From: Josh Paetzel To: Nathan Vidican Cc: questions@freebsd.org Subject: Re: using PERL on FreeBSD to get data from MS Access... any ideas? Message-ID: <20021006071611.GF20787@ns1.webwarrior.net> References: <000501c26cac$7838ac70$f69508d8@78lb019> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <000501c26cac$7838ac70$f69508d8@78lb019> User-Agent: Mutt/1.4i Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Sat, Oct 05, 2002 at 04:19:10PM -0400, Nathan Vidican wrote: > Has anyone successfully been able to work with Microsoft Access > database-stored data from PERL on a FreeBSD box? > > Here's the deal: > > We've got a rather large Microsoft Access Database, the database is used > to keep track of several leagues, their teams and players involved and all > stats regarding any of the above. We need to find a way to securely access > and display the data about the team/player stats on a per-league basis over > the internet. Posting the entire database out onto public domain would allow > anyone to download the whole thing and in essence 'steal' all the work done > to create the project over the years. This is something that the DB creator > obviously doesn't want to happen. > Any ideas on how we might be able to create pages on the server-side > (FreeBSD/Apache) of the webserver to dynamically display stats and such > information to the public? I understand fully what's rewquired on the > programming side as far as interfaces/etc, (could do this no problem if the > database was in mysql personally). The short version: need to find a > server-side solution (prefereably using PERL:DBI) which will allow a CGI > application to access a Microsoft Access database. > > -- > Nathan Vidican > nathan@vidican.com > Google turned this up, I've never used it. http://www.wdvl.com/Authoring/Languages/Perl/PerlfortheWeb/simple_query.html Josh To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message