> I'm not sure if this is the right place, but here goes my problem:
> I'm running Apache::ASP on apache 1.3.14 with mod_perl 1.24_01 on a i686
> with RH 6.2. I've got a database query system written in ASP that at some
> point uses an ODBC connection to an MS Acess database to query it. The
> unusual thing is that both ODBC components need to run on the linux box
> and that therefore there can be no NT box involved. I'm basically trying
> to migrate the whole thing from a Windows NT 4 box to my linux box.
> Is there a free / GPL app that can help me accomplish this and where could
> I find a detailed manual on it? Or are there any appropriate resources
> online where I should look?
Presumably your ASP system is currently written in VBScript or JavaScript.
Apache::ASP requires that you write your script in Perl, so you'll have to
do some rewriting.
You'll also have to deal with migration of the Access database, which isn't
really mod_perl related, so you might prefer to email me directly if you
need more help beyond what follows...
Basically, I'd suggest moving to a light-weight Linux database rather than
trying to use an Access DB through ODBC, if you have to get NT out of the
equation. MySQL (www.mysql.org) has a similar feature set to Access,
although it is a server-based rather than file-based database system. It
does not support transactions, updatable joins, or subqueries--if you need
these you could try PostgreSQL (www.postgresql.org).
To transfer your database you can use MyODBC to create a connection to your
MySQL database from Windows, and then create Make Table queries in Access
setting the destination database to your MySQL database in View->Properties.
You'll have to create indexes yourself if you take this route. I've got a
VBA script that creates MySQL scripts from an Access DB that I can send you
if you prefer, although it's a bit flakey.
