From owner-freebsd-questions Sat Oct 5 23:37:35 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 7B73637B401 for ; Sat, 5 Oct 2002 23:37:34 -0700 (PDT) Received: from sub21-156.member.dsl-only.net (sub21-156.member.dsl-only.net [63.105.21.156]) by mx1.FreeBSD.org (Postfix) with ESMTP id D3B3443E6E for ; Sat, 5 Oct 2002 23:37:33 -0700 (PDT) (envelope-from nkinkade@dsl-only.net) Received: from sub21-156.member.dsl-only.net (freebsd.localhost.localdomain [127.0.0.1]) by sub21-156.member.dsl-only.net (8.12.5/8.12.4) with SMTP id g966jmfh000317; Sat, 5 Oct 2002 23:45:48 -0700 (PDT) (envelope-from nkinkade@dsl-only.net) Date: Sat, 5 Oct 2002 23:45:43 -0700 From: Nathan Kinkade To: "Nathan Vidican" Cc: questions@freebsd.org Subject: Re: using PERL on FreeBSD to get data from MS Access... any ideas? Message-Id: <20021005234543.521fbb5d.nkinkade@dsl-only.net> In-Reply-To: <000501c26cac$7838ac70$f69508d8@78lb019> References: <000501c26cac$7838ac70$f69508d8@78lb019> X-Mailer: Sylpheed version 0.7.8claws (GTK+ 1.2.10; i386-portbld-freebsd4.6) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit 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, 5 Oct 2002 16:19:10 -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. Doesn't Access support ODBC connections? If so, you could just use the perl DBI module to extract the data. Nathan To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message