From owner-freebsd-questions Sun Oct 6 7:37:39 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 9DDCB37B401 for ; Sun, 6 Oct 2002 07:37:37 -0700 (PDT) Received: from serv1.wallnet.com (server1.wallnet.com [208.225.162.122]) by mx1.FreeBSD.org (Postfix) with ESMTP id D7AD143E3B for ; Sun, 6 Oct 2002 07:37:36 -0700 (PDT) (envelope-from timothyk@serv1.wallnet.com) Received: (from root@localhost) by serv1.wallnet.com (8.11.5/8.11.5) id g96EbaY87456; Sun, 6 Oct 2002 10:37:36 -0400 (EDT) (envelope-from timothyk@serv1.wallnet.com) Received: from localhost (timothyk@localhost) by serv1.wallnet.com (8.11.5/8.11.5av) with ESMTP id g96EbSx87445; Sun, 6 Oct 2002 10:37:28 -0400 (EDT) (envelope-from timothyk@serv1.wallnet.com) X-Authentication-Warning: serv1.wallnet.com: timothyk owned process doing -bs Date: Sun, 6 Oct 2002 10:37:28 -0400 (EDT) From: Tim Kellers To: Nathan Kinkade Cc: Nathan Vidican , Subject: Re: using PERL on FreeBSD to get data from MS Access... any ideas? In-Reply-To: <20021005234543.521fbb5d.nkinkade@dsl-only.net> Message-ID: <20021006102519.N86400-100000@serv1.wallnet.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS perl-11 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 Not quite as elegant as using the p5-DBI, but... At work we have scads of Access databases feeding data to IIS/Cold Fusion driving our website. In order to get off the Access bandwagon and sanely migrate data to FreeBSD/apache, I've begun to move the Access db's to MS SQL 7.0 (a cousin of PostgresQL), and then into a postgresdb on a FreeBSD server using a handy tool called pgadmin2. While I'm writing the php code to switch the pages from Cold Fusion/IIS to php/apache/postgresql the original Cold Fusion server can see and write to the new database as well as the Access databases; I can change over the webpages one at a time while not having to change over the entire website in one fell swoop. Not exactly what you originally asked, but importing the data into a SQL database isn't particularly painful, and the improvement in flexibility for displaying selected data on a webpage is more than just considerable. Tim Kellers CPE/NJIT On Sat, 5 Oct 2002, Nathan Kinkade wrote: > 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 > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message