http://qs321.pair.com?node_id=372274


in reply to Creating Win32 User Interfaces with Perl

Thankyou all for your responses (overwhelming). I have been investigating the Tk module to use as the Frontend for this database. This is a Microsoft SQL 2000 Database and I have creating a connection using the DBI and DBD::ODBC module combination. We will be using the MSDE version of Microsoft SQL as it runs on a non server windows platform (its also free). This is for my final project of my degree. I am just wanting to create an interface to do basic inserts and searches of the database. I was wanting to use Perls Chart abilities to create reports as well as the SENDMAIL module to create an ordering system.It seems like a lot of overhead required (eg installing web server) to create a CGI perl based interface. In addition, this system requires the need to create reports based on database data. Can i integrate Microsoft Office applications? Is there an alternative? Tk looks nice, but a lot of work compared to a CGI interface through a novice perl programmer eyes. Thankyou for your expertise.

Replies are listed 'Best First'.
Re^2: Creating Win32 User Interfaces with Perl
by toma (Vicar) on Jul 08, 2004 at 07:58 UTC
    A really great way to make database reports is with the Spreadsheet::WriteExcel module. It creates .xls files that work in Excel (and some other spreadsheets). You can put bitmaps and fancy formatting in the spreadsheet. It does not have commands for drawing graphs.

    Database output is often tabular, so a set of linked worksheet tabs can be a great way to present data.

    It should work perfectly the first time! - toma
Re^2: Creating Win32 User Interfaces with Perl
by disciple (Pilgrim) on Jul 12, 2004 at 12:14 UTC

    Just an FYI about the performance of the MSDE. This quote taken from this page.

    MSDE is designed for low volume applications. There is a workload governor that will degrade performance if there are more than five concurrent batch workloads. As more workloads are added, the system will continue to slow.