Sunday, January 30, 2011

how to install perl modules

One of the simplest ways to install Perl Modules, with ActiveState Perl Package Manager.

If you're lucky enough to host your Perl apps in a server without firewall and proxy constraints...
Just launch DOS and run ppm!
e.g.
c:\>ppm
ppm>install PAR-Packer
bla bla bla....
ppm>exit

If your server is residing behind a firewall or is using proxy, the most common problem you will see is "Could not locate a PPD file for package xxxX".
A simpler alternative (than consulting the network admin and setting proxy env vars) would be to:
Search for PPM packages at http://ppm4.activestate.com/ or numerous other repositories such as http://www.bribes.org/perl/ppmdir.html
Download the Perl module archive (tar.gz) and the .ppd file, and place them in a local directory. Make sure the path does not contain spaces.
Launch ppm from command line and set the repository to your local directory.
e.g.
c:\>ppm
ppm>set rep Local c:\perl\addon
ppm>set
ppm>install PAR-Packer

Thursday, January 27, 2011

How to create exe from Perl files

Option 1: Use a Perl package such as PAR or PAR-Packer.
Assuming you have installed ActiveState ActivePerl, just go to command prompt and run the following:
ppm (launch perl package manager)
search (confirm the package available for download)
install

More info:
PAR-Packer: http://search.cpan.org/~rschupp/PAR-Packer-1.008/lib/pp.pm
example: pp -o packed.exe source.pl

Option 2: Use Perl2Exe.
http://www.indigostar.com/perl2exe.php
Download the version compatible with your Perl Installation and unzip the contents. Refer to the readme for more info.
Basically the command should just be perl2exe yourscriptname.pl

Option 3:
Use perlcc built-in command. I 'm not sure whether this works for Windows though.

Tuesday, January 25, 2011

web based administration for SQL server 2005

Purpose: a relatively fast and economical solution to administer SQL Server 2005 over the web. Ever heard of php myAdmin?

Main components needed in the host server:
- SQL Native Client
- Microsoft SQL Server 2005 Management Objects Collection* (optional)
- Microsoft SQL Server 2005 Backward Compatibility Components
- SQL Web Data Administrator (For my case I am using SQL Server 2005)

Both SQL Native Client and Microsoft SQL Server 2005 Management Objects Collection can be found from Microsoft Downloads: http://www.microsoft.com/downloads/en/details.aspx?familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en

SQL Web Data Administrator is an open source project as of now; it is not officially supported by Microsoft. Use at your own risk!

Steps:
1. Download the required executables from Microsoft Library.
2. Download SqlWebAdmin source code from codeplex. Codeplex is an open source repository for .NET code. http://sqlwebadmin.codeplex.com/. Setup instructions can be found in the project site so I'm not going to elaborate.
3. Compile the source code locally if needed.
4. Install SQL Native Client (sqlncli.msi) and Microsoft SQL Server 2005 Backward Compatibility Components (SQLServer2005_BC.msi). For the latter, it is sufficient to pick SQL Distributed Management Objects (SQL-DMO) feature and disable all other features.

Alternatively, you can download the free lite version of myLittleAdmin at http://www.mylittletools.net/en/welcome.aspx

Tuesday, January 18, 2011

where can I find Oracle Client 9i?

Go to http://edelivery.oracle.com/EPD/Search/handle_go

Select the two check boxes and click on Continue.
In the next page select Oracle Database as Product Pack and pick OS.

Click Go for Searching.
in the result sheet, Click on 'Oracle9i Database Release 2 (9.2.0.1.0) Media Pack for Microsoft Windows'

Click download on for 'Oracle9i Client Release 2 (9.2.0.1.0) for Microsoft Windows 98/NT/2000/XP'

Lost installation product key?

Remote login to similar server and run regedit.
Locate the entries - it's probably under My Computer - HKEY_LOCAL_MACHINE - SOFTWARE
If you're lucky you might find the product key in the registry.
Related Posts Plugin for WordPress, Blogger...