Chip: Windows 2000 Professional Resource Kit

home *** CD-ROM | disk | FTP | other *** search

/ Chip: Windows 2000 Professional Resource Kit / W2KPRK.iso / apps / perl / ActivePerl.exe / data.z / perlwin32faq9.html < prev next >

Wrap

Extensible Markup Language | 1999-10-15 | 29.2 KB | 859 lines

<?xml version="1.0"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/transitional.dtd"> <html xmlns="http://www.w3.org/TR/xhtml1"> <head> <title>perlwin32faq9 - Modules and sample scripts</title> <link rev="made" href="mailto:bjepson@debian.ids.net" /> <meta name="GENERATOR" charset="iso-8859-1" /> <link rel="STYLESHEET" href="../win32prk.css" type="text/css" media="screen" /> </head> <body bgcolor="#ffffff">  <table width="100%"> <tr> <td bgcolor="000000" width="70" height="31"><a href= "http://www.activestate.com/"><img src="ASbutton.gif" alt= "ActiveState Home Page" border="0" width="68" height= "30" /></a></td> <td width="10" bgcolor="#ffffff"> </td> <td valign="middle" bgcolor="#cc0066"> Win32 FAQ</td> </tr> </table>  <ul> <li><a href="#NAME">NAME</a></li> <li> <a href="#DESCRIPTION">DESCRIPTION</a> <ul> <li><a href="#How_can_I_use_modules_from_CPAN_">How can I use modules from CPAN?</a></li> <li><a href="#Where_do_I_get_a_Win32_make">Where do I get make for Win32?</a></li> <li><a href="#How_do_I_access_databases_from_m">How do I access databases from my Perl script?</a></li> <li><a href="#Is_there_a_way_to_use_OLE_Automa">Is there a way to use OLE Automation servers from my Perl script?</a></li> <li><a href="#Is_there_a_way_to_access_Data_Ac">Is there a way to access Data Access Objects (DAO) from my Perl</a></li> <li><a href="#Can_I_send_Internet_mail_from_Pe">Can I send Internet mail from Perl for Win32?</a></li> <li><a href="#Is_there_a_way_to_access_MAPI_fr">Is there a way to access MAPI from my Perl script?</a></li> <li><a href="#Is_there_a_DBM_implementation_av">Is there a DBM implementation available for Perl for Win32?</a></li> <li><a href="#Is_there_a_GDBM_available_for_Pe">Is there a GDBM available for Perl for Win32?</a></li> <li><a href="#Is_there_a_way_to_do_GUI_program">Is there a way to do GUI programming with Perl for Win32?</a></li> <li><a href="#Is_there_a_port_of_Oraperl_for_W">Is there a port of Oraperl for Win32?</a></li> <li><a href="#What_modules_come_with_the_Perl_">What modules come with the Perl for Win32 distribution?</a></li> <li><a href="#Where_can_I_find_other_modules_f">Where can I find other modules for Perl for Win32?</a></li> <li><a href="#Is_there_a_GD_module_available_f">Is there a GD module available for Perl for Win32?</a></li> <li><a href="#What_is_CPAN_and_how_do_I_use_it">What is CPAN and how do I use it?</a></li> <li><a href="#Is_there_a_library_to_read_or_wr">Is there a library to read or write Microsoft Office or other</a></li> </ul> </li> <li><a href="#AUTHOR_AND_COPYRIGHT">AUTHOR AND COPYRIGHT</a></li> </ul>  <hr /> <h1><a name="NAME">NAME</a></h1> perlwin32faq9 - Modules and sample scripts <hr /> <h1><a name="DESCRIPTION">DESCRIPTION</a></h1> <hr /> <h2><a name="How_can_I_use_modules_from_CPAN_">How can I use modules from CPAN?</a></h2> As of version 5.005, Perl for Win32 supports the MakeMaker utility. This allows you to install modules from CPAN, but requires you to have a make utility, such as nmake or dmake. Modules are generally distributed in gzipped tar files, such as Data-Dumper-2.08.tar.gz. However, Perl for Win32 includes the Perl Package Manager (PPM), a utility that allows you to install modules, including modules that contain binary extensions. You should consider using PPM to install a module, as this greatly simplifies the management of modules. Nevertheless, there are times when it is necessary to build a module from source. Typically, an installation session goes something like this: <ol> <li> <a name="item_"></a> Extract the module. This creates a directory based on the name of the archive. <pre> gzip -d -c Data-Dumper-2.08.tar.gz | tar xvf - </pre> </li> <li> Change directory to the module's directory. <pre> cd Data-Dumper-2.08 </pre> </li> <li> Consult the README file. <pre> more < README </pre> </li> <li> Run the Makefile.PL script. This uses the MakeMaker module to build a makefile you can build the extension with. <pre> perl Makefile.PL </pre> </li> <li> Run your make utility. This prepares the module for installation, and compiles any extension if one is present. <pre> nmake </pre> </li> <li> If this module has tests, run them. <pre> nmake test </pre> </li> <li> If the tests succeeded, install the module. <pre> nmake install </pre> </li> </ol> See <a href= "perlwin32faq4.html#Where_can_I_find_Win32_ports_of_">Where can I find Win32 ports of UNIX tools?</a> for information on the availability of tools like gzip and tar. <hr /> <h2><a name="Where_do_I_get_a_Win32_make">Where do I get make for Win32?</a></h2> <dl> <dt><a name="item_nmake">nmake</a></dt> <dd> nmake is a 'make' like program for Win32 systems by Microsoft. It is available from <a href= "ftp://ftp.microsoft.com/Softlib/MSLFILES/nmake15.exe"> ftp://ftp.microsoft.com/Softlib/MSLFILES/nmake15.exe</a> </dd> </dl> <hr /> <h2><a name="How_do_I_access_databases_from_m">How do I access databases from my Perl script?</a></h2> <dl> <dt><a name="item_ADO">ADO</a></dt> <dd> The ActiveX Data Objects (ADO) API can be used with the Win32::OLE module. You can use ADO to access any ODBC data source. The Perl-Win32-Database FAQ includes some information on ADO: <pre> <a href= "http://www.fastnetltd.ndirect.co.uk/Perl/perl-win32-database.html">http://www.fastnetltd.ndirect.co.uk/Perl/perl-win32-database.html</a> </pre> The ADO home page is located at: <pre> <a href= "http://www.microsoft.com/data/ado/">http://www.microsoft.com/data/ado/</a> </pre> </dd> <dt><a name="item_Win32"> Win32::ODBC</a></dt> <dd> There are a couple of extensions that have been developed to access databases from Perl for Win32. Win32::ODBC is widely popular, and is available on CPAN and at this URL: <pre> <a href= "http://www.roth.net/odbc/">http://www.roth.net/odbc/</a> </pre> </dd> <dt><a name="item_DBI">DBI</a></dt> <dd> DBI, a Database Interface Module for Perl provides a consistent interface for database application development. DBI supports ODBC drivers as well as the native APIs of certain databases, including Oracle. The DBI home page is located at: <pre> <a href= "http://www.hermetica.com/technologia/perl/DBI/index.html">http://www.hermetica.com/technologia/perl/DBI/index.html</a> </pre> </dd> <dt><a name="item_Sybase">Sybase</a></dt> <dd> The Sybperl module allows you to connect to Sybase SQL Server (and possibly Microsoft SQL Server). The Sybperl home page, which includes links to binary releases of Sybperl, is located at: <pre> <a href= "http://www.mbay.net/~mpeppler/">http://www.mbay.net/~mpeppler/</a> </pre> </dd> </dl> If you choose to use a database API that depends on ODBC, you must have an ODBC driver for the DBMS you're using. You will need to configure a data source for that driver on each machine that needs to access the database. For more information on ODBC and how to configure a data source, check the ODBC Control Panel help. Some DBMSs, such as Microsoft Access and Microsoft SQL Server, can be controlled through OLE Automation (see the next question). See the product documentation for details. <hr /> <h2><a name="Is_there_a_way_to_use_OLE_Automa">Is there a way to use OLE Automation servers from my Perl script?</a></h2> Yes. See the documentation for the Win32::OLE module, which is included with Perl. You can use Win32::OLE to control a wide range of Win32 applications and APIs, including ADO. After reading the documentation, you can read the <a href= "perlwin32faq12.html">FAQ on using OLE</a>. <hr /> <h2><a name="Is_there_a_way_to_access_Data_Ac">Is there a way to access Data Access Objects (DAO) from my Perl script?</a></h2> You should use Win32::OLE to access this API. See question <a href= "#Is_there_a_way_to_use_OLE_Automa">Is there a way to use OLE Automation servers from my Perl script?</a> and consult the DAO documentation. <hr /> <h2><a name="Can_I_send_Internet_mail_from_Pe">Can I send Internet mail from Perl for Win32?</a></h2> If you need to send Internet mail, you should use Net::SMTP, Mail::Sender, or Mail::Sendmail. For more information on these modules, see <a href= "perlwin32faq4.html#How_do_I_send_email_from_Perl_fo">How do I send email from Perl for Win32?</a>. <hr /> <h2><a name="Is_there_a_way_to_access_MAPI_fr">Is there a way to access MAPI from my Perl script?</a></h2> You can use the Win32::OLE module to create an instance of a MAPI session and send a message. In order for this to work, you must have messaging configured correctly on your machine. If you can are using Microsoft Exchange, chances are this will work fine. If you need to send Internet mail, you should use Net::SMTP. For more information on Net::SMTP, see <a href= "perlwin32faq4.html#How_do_I_send_email_from_Perl_fo">How do I send email from Perl for Win32?</a>. Here is an example script that sends mail using MAPI: <pre> # Sender's Name and Password # my $sender = "YOUR NAME HERE"; my $passwd = "YOUR PASSWORD HERE"; use Win32::OLE; # MAPI.Session needs the specialized COINIT_OLEINITIALIZE flag. # (Most other components do not need it, see the OLE # documentation for more about this.) # Win32::OLE->Initialize(Win32::OLE::COINIT_OLEINITIALIZE); # Create a new MAPI Session # $session = Win32::OLE->new("MAPI.Session") or die "Could not create a new MAPI Session: $!"; # Attempt to log on. # my $err = $session->Logon($sender, $passwd); if ($err) { die "Logon failed: $!"; } # Add a new message to the Outbox. # $msg = $session->Outbox->Messages->Add(); # Add the recipient. # $rcpt = $msg->Recipients->Add(); $rcpt->{Name} = "RECIPIENT NAME HERE"; $rcpt->Resolve(); # Create a subject and a body. # $msg->{Subject} = "Test Message"; $msg->{Text} = <<EOF; This is a sample test message. Cheers, Mr. Email EOF # Send the message and log off. # $msg->Update(); $msg->Send(0, 0, 0); $session->Logoff(); </pre> <hr /> <h2><a name="Is_there_a_DBM_implementation_av">Is there a DBM implementation available for Perl for Win32?</a></h2> Yes, there is. SDBM_File is a free clone of DBM, and is implemented and distributed with the Perl for Win32 distribution. You can use it as follows: <pre> use SDBM_File; use Fcntl; tie( %myhash, "SDBM_File", 'myfile', O_RDWR | O_CREAT | O_BINARY, 0666 ) or die( "Can't tie: $!" ); $myhash{"bibim"} = "bap"; untie( %myhash ); </pre> After the DBM file is tied, you can use it just like any other hash. <hr /> <h2><a name="Is_there_a_GDBM_available_for_Pe">Is there a GDBM available for Perl for Win32?</a></h2> GDBM, NDBM, and ODBM do not build on Win32. <hr /> <h2><a name="Is_there_a_way_to_do_GUI_program">Is there a way to do GUI programming with Perl for Win32?</a></h2> As of the Perl Resource Kit for Win32, the Tk library has been successfully ported to Perl for Win32. Tk version 8xx and above also now has the look and feel of Windows programs, and not the old UNIX look of previous versions. You can also use the Win32::GUI module which also allows for GUI's to be made/manipulated using Perl. This module uses the standard Windows widgets to give the look and feel of Windows programs. For Tk information, go to <a href= "http://w4.lns.cornell.edu/~pvhp/ptk/ptkTOC.html"> http://w4.lns.cornell.edu/~pvhp/ptk/ptkTOC.html</a> For Win32::GUI, go to <a href= "http://www.divinf.it/dada/perl/gui/"> http://www.divinf.it/dada/perl/gui/</a>. <code>Win32::MsgBox</code> allows for a fast and easy way to display a Windows message box, for example: <blockquote> <code>use Win32; MsgBox("Test", "This is a test", 48); # display a message box with an exclamation mark and an 'Ok' button sub MsgBox { my ($caption, $message, $icon_buttons) = @_; my @return = qw/- Ok Cancel Abort Retry Ignore Yes No/; my $result = Win32::MsgBox($message, $icon_buttons, $caption); return $return[$result]; }</code> </blockquote> The last value, $icon_buttons, is the sum of two values, the value for the icon and the value for the buttons. For example, if you need a message box with a question mark and the 'Ok' and 'Cancel' buttons the value you want is 32 (question mark) + 1 (Ok, Cancel) = 39. The values are listed here: <blockquote> <code>Icons: 0 - no icon 16 - Hand 32 - Question 48 - Exclamation 64 - Asterisk Buttons: 0 - Ok 1 - Ok, Cancel 2 - Abort, Retry, Ignore 3 - Yes, No, Cancel 4 - Yes, No 5 - Retry, Cancel</code> </blockquote> <hr /> <h2><a name="Is_there_a_port_of_Oraperl_for_W">Is there a port of Oraperl for Win32?</a></h2> Oraperl is available as an emulation layer on top of DBD::Oracle. Oraperl is included with the DBD::Oracle distribution. Because the DBI interface is evolving, the Oraperl emulation layer is recommended because its API is fairly stable. Patches are available for DBD::Oracle that allow it to build on Windows NT. More information is available at: <pre> <a href= "http://www.hermetica.com/technologia/perl/DBI/win32/index.html">http://www.hermetica.com/technologia/perl/DBI/win32/index.html</a> </pre> Binary distributions of DBI and DBD::Oracle are available from: <pre> <a href= "http://www.access.digex.net/~jurlwin/">http://www.access.digex.net/~jurlwin/</a> </pre> <hr /> <h2><a name="What_modules_come_with_the_Perl_">What modules come with the Perl for Win32 distribution?</a></h2> Along with the standard library files, there are several Win32-specific modules that are distributed with Perl for Win32. These include: <ul> <li><a name="item_Win32">Win32::Clipboard: Perl module for Windows clipboard interaction</a></li> <li><a name="item_Win32">Win32::Console: Perl module for Windows console interaction</a></li> <li><a name="item_Win32">Win32::ChangeNotification: Create and use ChangeNotification objects</a></li> <li><a name="item_Win32">Win32::Event: Use Win32 event objects from Perl</a></li> <li><a name="item_Win32">Win32::EventLog: Read from and write to the Windows NT event log</a></li> <li><a name="item_Win32">Win32::File: Manage file attributes (read only, system, hidden...)</a></li> <li><a name="item_Win32">Win32::FileSecurity: manage ACLs in Perl</a></li> <li><a name="item_Win32">Win32::Internet: Perl module for Internet extensions</a></li> <li><a name="item_Win32">Win32::IPC: Wait for objects (processes, mutexes, semaphores)</a></li> <li><a name="item_Win32">Win32::Mutex: Create and use mutexes</a></li> <li><a name="item_Win32">Win32::NetAdmin: Administer users and groups</a></li> <li><a name="item_Win32">Win32::NetResource: Manage resources (servers, file shares, printers)</a></li> <li><a name="item_Win32">Win32::ODBC: work with ODBC data sources</a></li> <li><a name="item_Win32">Win32::OLE: Use OLE automation from Perl</a></li> <li><a name="item_Win32">Win32::Pipe: Perl module for pipes</a></li> <li><a name="item_Win32">Win32::Process: Start and stop Win32 processes</a></li> <li><a name="item_Win32">Win32::Registry: Read and manage the Win32 Registry</a></li> <li><a name="item_Win32">Win32::Semaphore: Create and use semaphores</a></li> <li><a name="item_Win32">Win32::Service: Manage Windows NT services</a></li> <li><a name="item_Win32">Win32::Shortcut: Perl module for shell link interface</a></li> <li><a name="item_Win32">Win32::WinError: For retrieving Win32-defined errors</a></li> </ul> These are documented on the Win32mod documentation page. There are also a number of subs built into the Win32 package, namely: <ul> <li><a name="item_AbortSystemShutdown"> AbortSystemShutdown: I mean, don't shut down this computer</a></li> <li><a name="item_DomainName">DomainName: Name of the domain this machine is in</a></li> <li><a name="item_ExpandEnvironmentStrings"> ExpandEnvironmentStrings: Take a string like %HOMEPATH% and expand it to the actual value</a></li> <li><a name="item_FormatMessage">FormatMessage: Format a Win32 error code into a error message</a></li> <li><a name="item_FsType">FsType: Get the file system type of a drive</a></li> <li><a name="item_GetCwd">GetCwd: Get current working directory</a></li> <li><a name="item_GetLastError">GetLastError: Retrieve the last Win32 error code.</a></li> <li><a name="item_GetNextAvailDrive"> GetNextAvailDrive: Returns the next available drive letter</a></li> <li><a name="item_GetOSVersion">GetOSVersion: Get Win32 operating system version</a></li> <li><a name="item_GetShortPathName">GetShortPathName: Returns the 8.3 name of a filename</a></li> <li><a name="item_GetTickCount">GetTickCount: Time since Windows started, in milliseconds (for timing)</a></li> <li><a name="item_InitiateSystemShutdown"> InitiateSystemShutdown: Shut down this computer</a></li> <li><a name="item_IsWinNT">IsWinNT: Is this Windows NT?</a></li> <li><a name="item_IsWin95">IsWin95: Or, is it Windows 95?</a></li> <li><a name="item_LoginName">LoginName: Name of logged-in user</a></li> <li><a name="item_LookupAccountName"> LookupAccountName: Given a user name, get domain, SID, SID type</a></li> <li><a name="item_LookupAccountSID">LookupAccountSID: Given a SID, get domain, user name, SID type</a></li> <li><a name="item_NodeName">NodeName: Name of this machine</a></li> <li><a name="item_SetCwd">SetCwd: Set current working directory</a></li> <li><a name="item_Sleep">Sleep: Sleep for a given number of milliseconds</a></li> <li><a name="item_Spawn">Spawn: Spawn a Win32 process</a></li> <li><a name="item_ExpandEnvironmentStrings"> ExpandEnvironmentStrings: Take a string like %HOMEPATH% and expand it to the actual value</a></li> </ul> No longer included in the Win32 module: <ul> <li><a name="item_PerlVersion">PerlVersion: Use $] instead</a></li> <li><a name="item_GetArchName">GetArchName: Use $ENV{PROCESSOR_ARCHITECTURE}</a></li> <li><a name="item_GetChipName">GetChipName: Use $ENV{PROCESSOR_LEVEL} . $ENV{PROCESSOR_ARCHITECTURE}</a></li> </ul> <hr /> <h2><a name="Where_can_I_find_other_modules_f">Where can I find other modules for Perl for Win32?</a></h2> Modules for Perl for Win32 are available on CPAN (Comprehensive Perl Archive Network), a Perl archive that's mirrored around the world. To find your nearest mirror, check here: <pre> <a href= "http://www.perl.com/perl/CPAN/modules/by-module/Win32/">http://www.perl.com/perl/CPAN/modules/by-module/Win32/</a> </pre> (Note that this will send you to your nearest mirror automagically. Cool, huh?) <hr /> <h2><a name="Is_there_a_GD_module_available_f">Is there a GD module available for Perl for Win32?</a></h2> GD now works with Win32, and can be installed using PPM (the Perl Package Manager). GD is also shipped with the Perl Resource Kit for Win32. This graphics library allows the creation and some manipulation of industry standard GIF format images. <hr /> <h2><a name="What_is_CPAN_and_how_do_I_use_it">What is CPAN and how do I use it?</a></h2> CPAN is the Comprehensive Perl Archive Network, a collection of pretty much every file you could ever want for Perl programming. The original archive is in Finland, but it is mirrored on FTP servers throughout the world. You can connect to your closest CPAN mirror using the CPAN redirector at <a href="http://www.perl.com.">http://www.perl.com.</a> The following URL: <pre> <a href= "http://www.perl.com/CPAN/">http://www.perl.com/CPAN/</a> </pre> will redirect your browser to the nearest CPAN mirror (one on your continent and maybe only a few hops away). This URL <pre> <a href="http://www.perl.com/CPAN">http://www.perl.com/CPAN</a> </pre> lets you pick a CPAN mirror site yourself, as well as giving a little more information. CPAN is good for finding Perl for Win32 distributions as well as modules and scripts. However, read <a href="#How_can_I_use_modules_from_CPAN_"></a> <pre> How can I use modules from CPAN? </pre> for more information. <hr /> <h2><a name="Is_there_a_library_to_read_or_wr">Is there a library to read or write Microsoft Office or other application files?</a></h2> In general, there aren't any library modules to read or write application files, like Microsoft Word, Microsoft Excel, Microsoft Access, WordPerfect, Lotus 1-2-3, etc. However, many if not most major Windows applications now support OLE Automation. You can use the OLE Automation support of Microsoft Office applications to read and write their file formats, for example. See the documentation on your application for information on its support for OLE Automation. See <a href="#Is_there_a_way_to_use_OLE_Automa">Is there a way to use OLE Automation servers from my Perl script?</a> for more information. As a special case, many database files, like Microsoft Access, FoxPro, dBase or Paradox files, can be accessed using ODBC (Open DataBase Connectivity). See <a href="#How_do_I_access_databases_from_m">How do I access databases from my Perl script?</a> for details on how to use ODBC with Perl for Win32. <hr /> <h1><a name="AUTHOR_AND_COPYRIGHT">AUTHOR AND COPYRIGHT</a></h1> This FAQ was originally assembled and maintained by Evangelo Prodromou. <a href= "mailto:evangelo@endcontsw.com">evangelo@endcontsw.com.</a> It has been revised and updated by Brian Jepson of O'Reilly and Associates, David Grove, David Dmytryshyn of ActiveState, Henning Michael Møller-Nielsen of RTO and Kevin Meltzer. This FAQ is in the public domain. If you use it, however, please ensure that you give credit to the original authors.  <table width="100%"> <tr> <td bgcolor="000000" width="70" height="31"><a href= "http://www.activestate.com/"><img src="ASbutton.gif" alt= "ActiveState Home Page" border="0" width="68" height= "30" /></a></td> <td width="10"> </td> <td valign="middle" bgcolor="#cc0066"> Win32 FAQ</td> </tr> </table>  </body> </html>