2009-02-04T03:28:00.001-08:00

Executing SQL Server Stored Procedure from Perl - Setup Perl and SQL Server on Windows

Perl’s running environment is integrated within the *nix system. For Microsoft Windows operating systems, however, you need to download and install it by yourself.

There are a few Windows-based distributions of Perl. ActivePerl from ActiveState.com may be the most popular one. You can download it from:

http://www.activestate.com/Products/ActivePerl/

Choose the latest version of ActivePerl (5.8) (most recent Unix/Linux also uses Perl 5.8).

Installing ActivePerl on Windows is fairly easy. After installation you can use the following command to verify that perl is working:

From command prompt, input:

Perl –v

It will show you something like:

This is perl, v5.8.0 built for MSWin32-x86-multi-thread
Copyright 1987-2002, Larry Wall

Download Sybase Adaptive Server 12.5 Developer Edition from the Sybase website for free: www.sybase.com/ase_125devel

Installing and configuring Sybase Adaptive Server is also as easy as MS SQL Server.

If you want to use MS SQL Server as a database, install MS SQL Server 7.0 with service pack 2.

Perl uses DBI/DBD architecture to access databases (DBI means Database Interface, DBD means Database Driver). With a specific DBD driver installed, Perl can use the same DBI API to support different database systems.

The DBI module is already installed with the ActivePerl distribution itself. In order to support SQL Server, we need to download the SQL Server DBD driver from cpan.org: www.cpan.org, search for the DBD-Sybase module, and download the latest version 1.01 source code: DBD-Sybase-1.01.tar.gz

Note: there are a few other DBD Drivers that support both Sybase and Microsoft SQL Server on Windows, such as DBD::ADO; however, they can only be used on a Windows platform.

In order to compile and install the DBD::Sybase source code, we need a C compiler installed on Windows (I use Microsoft Visual C++ 6.0), and make sure nmake.exe is available in the PATH.

Use a decompression utility (ie: Winzip) to extract DBD-Sybase-1.0.1.tar.gz to any available drive such as C:. You should now have the folder c:DBD-Sybase-1.01 that holds all the source code.

Change directory to the above folder, and issue the following command in the command prompt window:

Perl Makefile.PL

You may receive a warning message, such as missing the following library: libtcl.lib, libcomn.lib and libintl.lib.

Because we are using the Sybase CT-Library, libcs.lib and libct.lib are mandatory; others are optional, and we can ignore this warning. Sybase removes these static libraries from its version 12.5 of the Adaptive Server package. The run time libraries still do exist (ie: libtcl.dll, libcomn.dll, linintl.dll) See the following screenshot:

source :http://www.devarticles.com

----------------------------------------------

tampilkan-data

transfer-login

tutorial-mysql

visitor-online

tip xampp-security

tips Choose IP

tips stopping unwanted e-mail

tip protect against

tips preventing nimda worm

wood-tips

tips imda worm

wood-tips

mengiringsearchengine

Trik member-area

Trik Membuat-halman next

Trik membuat-security-code

Trik mengecek-karakter

Trik merubah-pswd root

Trik Noise-dimouse

Trik penerapan BUG

Trik penggabungan-2web

Trik perkenalan-dengan-php

Trik PHP-Login-script

Trik PHP-Tutorial

setupperl sql server