You need to pull in DBI and MySQL DBD from ppm.
(Perl Package Manager - That is active state's version of cpan)
Type ppm in a dos box the perl bin directory.
(This bypasses certain issues with the way NT does paths)
Use the search feature, look for DBI and DBD as keywords.

I have been using this combo for a few months now with good results.
I also added the CSV driver for in/exports. Recommended.

Lastly, get the ODBC driver for windows.
You can find this on the MySQL site, look in the windows section.
I had to screw around a bit to get it installed, but when it all works right
you can get into the database with Access.
This has proven handy for quick data touch-ups and reports.

Lastly, if you add Apache you have a good platform for serving data around
the office.
IMHO this knocks the socks off IIS and ASP.
You mileage may vary.

I have the same application running on x86 Linux and NT.
It works about the same on either platform.
Some things I learned when porting:
Case matters on Linux, don't forget to "grant all" to the user in your
connect string.
Also, make you CGI script executable.

The next task is to port my application to my SPARCstation 5 when it come in
off a training loan.
Write once, run everywhere; don't try this trick with Microsoft products.
They hardly work on windows, and they don't work on Linux at all!

Mark Browne

----- Original Message -----
From: "Marc Olivier" <mcolivier at earthlink.net>
To: <tclug-list at mn-linux.org>
Sent: Tuesday, April 23, 2002 10:54 PM
Subject: [TCLUG] Perl/MySQL/Windoz question


Hello. Newbie question. I have Perl and MySQL up and running on a Linux
platform. I can connect to my database now on Linux. However, I also have
ActiveState Perl on Windows NT at work, and MySQL, too. I can put stuff into
the database at work, too, but I can't access it to get hardcopy printouts
using Perl. There is a module, DBI that's missing, and apparently was not
included on the CD that came with the book. I did some research on the web,
and if I read things correctly, DBI on a Win32 platform is still
experimental. The other manual on MySQL discussed doing API with C and PHP.
I actually wanted to do everything under Perl right now (while it's still
fresh in my mind, and I'm a lot farther with Perl than with either C and PHP
is a complete mystery right now). Has anyone out there found DBD and DBI
modules that work under Windows, especially Windows NT 4.0 and 4.5 (I'm not
sure which, so I mentioned both)?

Thanks.
Marc

_______________________________________________
Twin Cities Linux Users Group Mailing List - Minneapolis/St. Paul, Minnesota
http://www.mn-linux.org
tclug-list at mn-linux.org
https://mailman.mn-linux.org/mailman/listinfo/tclug-list