Solved

Install DBI in WinXP

Posted on 2003-11-01
12
321 Views
Last Modified: 2010-03-04
where can i download DBI Module for Perl In WinXP(OS)??

and How can i install it into my computer  so i can connect to a sybase DB server
0
Comment
Question by:ramez-isu
  • 4
  • 2
  • 2
  • +2
12 Comments
 
LVL 18

Expert Comment

by:kandura
Comment Utility
If you're using activstate perl, you can install the necessary modules by opening a command prompt and typing
ppm install dbd-sybase
This will install all the DBI related modules as well.
0
 
LVL 5

Expert Comment

by:fantasy1001
Comment Utility
Download dbi module here if you need one
http://www.cpan.org/modules/index.html

The link provides information on how to install in details.

Thanks,
~ fantasy ~
0
 

Author Comment

by:ramez-isu
Comment Utility
i serach for DBi

and i found a lot of modules  which one i should install i don't know????

DBI         ANDYDUNC  Orac-alpha-1.2.6.tar.gz             355k  17 Oct 2001
DBI         TIMB      DBI-1.25.tar.gz                     242k  05 Jun 2002
DBI         TIMB      DBI-1.38.tar.gz                     293k  25 Aug 2003
DBI         TLOWERY   DBI-Shell-11.93.tar.gz               48k  03 Oct 2003

DBD         MEWP      DBD-Sybase-1.01.tar.gz              164k  08 Sep 2003

which is the best for me
0
 
LVL 18

Expert Comment

by:kandura
Comment Utility
for your requirements, get DBI and DBD-Sybase.

if you have Activestate perl, do the following in a command prompt:

    ppm install dbd-sybase

otherwise do

    perl -MCPAN -e"install DBI DBD::Sybase"

Both methods will install the appropriate versions for you.

0
 
LVL 5

Expert Comment

by:fantasy1001
Comment Utility
If you are using Activestate perl, then follow the step kandura gave.
If not, then only you install those package from cpan
Try to use this:
DBI         TIMB      DBI-1.38.tar.gz
 
Kindly follow the installation guide: http://www.cpan.org/modules/INSTALL.html

regards,
~ fantasy ~
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 18

Expert Comment

by:kandura
Comment Utility
I stand corrected ;^)

>>> C:\>perl -MCPAN -e"install DBI DBD::Sybase"
>>> Can't locate object method "DBI" via package "DBD::Sybase" (perhaps you forgot to load "DBD::Sybase"?) at -e line 1.

Apparently you can't install 2 modules on the command line using the CPAN module.

Still, doing

    perl -MCPAN -e"install DBI, DBD::Sybase"

is easier IMHO than downloading, decompressing, unpacking, building, installing...

Anyway, chances are that the OP is using Activestate, so this may all be irrelevant. :-)

Kandura
0
 

Expert Comment

by:acameron
Comment Utility
Ok:

1)Download nmake and put it in your windows directory.  You will need this to compile the module.

2)Make sure your DB is installed and working properly.

3)Download: http://search.cpan.org/CPAN/authors/id/T/TI/TIMB/DBI-1.38.tar.gz

4)Extract the tarbal with WinZip.  From the command line in the directory you extracted the files run perl Makefile.pl

5)Now run nmake

6)Now run nmake install

Good luck.
0
 

Author Comment

by:ramez-isu
Comment Utility
i do what you told me but there is an error in step no 5,6
the error is:
===================================================
C:\Perl\lib\DBI>nmake

Microsoft (R) Program Maintenance Utility   Version 1.50
Copyright (c) Microsoft Corp 1988-94. All rights reserved.

         C:\Perl\bin\perl.exe -IC:\Perl\lib -IC:\Perl\lib -MExtUtils::Command -e
 mkpath blib\lib\DBI
         C:\Perl\bin\perl.exe -IC:\Perl\lib -IC:\Perl\lib -MExtUtils::Command -e
 rm_f blib\lib\DBI\Changes.pm
        C:\Perl\bin\perl.exe -IC:\Perl\lib -IC:\Perl\lib -MExtUtils::Command -e
cp Changes blib\lib\DBI\Changes.pm
         rem
cp Driver_xst.h blib\arch\auto\DBI\Driver_xst.h
cp lib/DBI/ProfileDumper.pm blib\lib\DBI\ProfileDumper.pm
cp DBIXS.h blib\arch\auto\DBI\DBIXS.h
cp lib/DBI/DBD/Metadata.pm blib\lib\DBI\DBD\Metadata.pm
cp lib/DBD/NullP.pm blib\lib\DBD\NullP.pm
cp dbipport.h blib\arch\auto\DBI\dbipport.h
cp lib/DBI/Const/GetInfoReturn.pm blib\lib\DBI\Const\GetInfoReturn.pm
cp dbd_xsh.h blib\arch\auto\DBI\dbd_xsh.h
cp lib/DBI/Const/GetInfo/ANSI.pm blib\lib\DBI\Const\GetInfo\ANSI.pm
cp lib/DBI/Profile.pm blib\lib\DBI\Profile.pm
cp lib/DBI/PurePerl.pm blib\lib\DBI\PurePerl.pm
cp lib/DBI/FAQ.pm blib\lib\DBI\FAQ.pm
cp DBI.pm blib\lib\DBI.pm
cp lib/DBD/ExampleP.pm blib\lib\DBD\ExampleP.pm
cp lib/Bundle/DBI.pm blib\lib\Bundle\DBI.pm
cp lib/Win32/DBIODBC.pm blib\lib\Win32\DBIODBC.pm
cp lib/DBI/W32ODBC.pm blib\lib\DBI\W32ODBC.pm
cp lib/DBI/DBD.pm blib\lib\DBI\DBD.pm
cp lib/DBI/ProfileData.pm blib\lib\DBI\ProfileData.pm
cp lib/DBI/Const/GetInfoType.pm blib\lib\DBI\Const\GetInfoType.pm
cp lib/DBI/ProxyServer.pm blib\lib\DBI\ProxyServer.pm
cp lib/DBD/Proxy.pm blib\lib\DBD\Proxy.pm
cp dbi_sql.h blib\arch\auto\DBI\dbi_sql.h
cp lib/DBI/ProfileDumper/Apache.pm blib\lib\DBI\ProfileDumper\Apache.pm
cp Driver.xst blib\arch\auto\DBI\Driver.xst
cp lib/DBI/Const/GetInfo/ODBC.pm blib\lib\DBI\Const\GetInfo\ODBC.pm
cp lib/DBD/Sponge.pm blib\lib\DBD\Sponge.pm
         rem
         rem
        C:\Perl\bin\perl.exe -p -e "s/~DRIVER~/Perl/g" blib\arch\auto\DBI/Driver
.xst > Perl.xsi
        C:\Perl\bin\perl.exe -IC:\Perl\lib -IC:\Perl\lib C:\Perl\lib\ExtUtils/xs
ubpp  -typemap C:\Perl\lib\ExtUtils\typemap -typemap typemap Perl.xs > Perl.xsc
&& C:\Perl\bin\perl.exe -IC:\Perl\lib -IC:\Perl\lib -MExtUtils::Command -e mv Pe
rl.xsc Perl.c
        cl -c  -nologo -O1 -MD -Zi -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT -DHAV
E_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DPERL_MSVCRT_READFIX -
O1 -MD -Zi -DNDEBUG    -DVERSION=\"1.38\"  -DXS_VERSION=\"1.38\"  -IC:\Perl\lib\
CORE  Perl.c
'cl' is not recognized as an internal or external command,
operable program or batch file.
NMAKE : fatal error U1077: 'C:\WINDOWS\system32\cmd.exe' : return code '0x1'
Stop.

C:\Perl\lib\DBI>nmake install

Microsoft (R) Program Maintenance Utility   Version 1.50
Copyright (c) Microsoft Corp 1988-94. All rights reserved.

         rem
         rem
         rem
        cl -c  -nologo -O1 -MD -Zi -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT -DHAV
E_DES_FCRYPT -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DPERL_MSVCRT_READFIX -
O1 -MD -Zi -DNDEBUG    -DVERSION=\"1.38\"  -DXS_VERSION=\"1.38\"  -IC:\Perl\lib\
CORE  Perl.c
'cl' is not recognized as an internal or external command,
operable program or batch file.
NMAKE : fatal error U1077: 'C:\WINDOWS\system32\cmd.exe' : return code '0x1'
Stop.

C:\Perl\lib\DBI>
===================================================

so what i should do please???
and thanks a lot for your help
0
 

Expert Comment

by:acameron
Comment Utility
cl is the name of the Visual C++ compiler. If you don't have that, you
are out of luck, unfortunately.
0
 
LVL 18

Accepted Solution

by:
kandura earned 125 total points
Comment Utility
I found a link to a binary package of this module: http://crazyinsomniac.perlmonk.org/perl/ppm/

HTH
0
 
LVL 20

Expert Comment

by:jmcg
Comment Utility
Nothing has happened on this question in more than 8 weeks. It's time for cleanup!

My recommendation, which I will post in the Cleanup topic area, is to
accept answer by kandura (with acknowledgement to acameron for effort).

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jmcg
EE Cleanup Volunteer
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

On Microsoft Windows, if  when you click or type the name of a .pl file, you get an error "is not recognized as an internal or external command, operable program or batch file", then this means you do not have the .pl file extension associated with …
Email validation in proper way is  very important validation required in any web pages. This code is self explainable except that Regular Expression which I used for pattern matching. I originally published as a thread on my website : http://www…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now