jehuni has asked for the wisdom of the Perl Monks concerning the following question:

Looks like we're finally getting the opportunity to dump Win2K/IIS/ASP and move to *nix/Apache/mod_perl. (Woo hoo!!!) Problem is, for now at least, we have to keep the databases in SQL Server 2000.

So, the question is: What kind of experiences/recommendations does anyone have with this kind of cross-platform setup?

None of us here have experience in this exact arena, so we're still actively looking for a solid approach. However, here are some of the possibilities we're considering, based mostly on perusing the web for ideas:

So ... tell us what you think ...