Date: Sun, 6 Oct 2002 10:37:28 -0400 (EDT) From: Tim Kellers <timothyk@serv1.wallnet.com> To: Nathan Kinkade <nkinkade@dsl-only.net> Cc: Nathan Vidican <nathan@vidican.com>, <questions@freebsd.org> Subject: Re: using PERL on FreeBSD to get data from MS Access... any ideas? Message-ID: <20021006102519.N86400-100000@serv1.wallnet.com> In-Reply-To: <20021005234543.521fbb5d.nkinkade@dsl-only.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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" <nathan@vidican.com> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20021006102519.N86400-100000>