Re: got problem with installing DBI
- From: alexander@xxxxxxxx (Alexander Foken)
- Date: Thu, 26 Jan 2006 12:16:57 +0100
nmake is available for free from Microsoft, use Google for the URL.
It is included in VC++, but not always installed properly. Search and run vcvars32.bat in the DOS window you run makefile.pl and nmake.
Why don't you simply use ActivePerl and the packages found at ppm.activestate.com? (For AP 5.8, you need a third party DBD::Oracle, google for it. For AP 5.6, AS has a DBD::Oracle.)
To connect via DBI (on any platform) to Oracle (on any platform), you have to install the Oracle client software on the machine running DBI, preferably the same version that runs on the server, but Oracle can also handle older and newer clients. This must happen before you try to compile DBD::Oracle. A common trap on Win32 is that Oracle 9 and newer does not automatically install the required OCIW32.DLL. It does when you tell the setup program to install the ODBC(!) drivers. Another trap is an ancient version of OCIW32.DLL installed somewhere outside the Oracle directory by some third party software.
First make sure your Oracle client software works properly, i.e. run something like "select 42 as answer from dual" in SQL plus, *then* start with Perl and DBI.
I have a "Oracle trouble shooting HOWTO", originally written for a custom software using DBI. I doubt I have the permission to publish it, but I can remove the product names and mail it to you, just send me a direct mail (not via dbi-users).
Alexander
Nizar LAHYANI wrote:
Hello everybody i got concerns when installing DBI that is after making perl Makefile.pl there is noway to exécute make or nmake or dmake (command not found) after that can anyone give me a simple example whith connecting from Windows to an Oracle Databse that is on an AIX system ?
Hope that you are very fine Thanks
here is my terminal output :
C:\pl\tools\DBI\DBI-1.48>dir Le volume dans le lecteur C n'a pas de nom. Le numéro de série du volume est 7883-A83E
Répertoire de C:\pl\tools\DBI\DBI-1.48
26/01/2006 09:38 <DIR> . 26/01/2006 09:38 <DIR> .. 14/03/2005 17:45 78 270 Changes 14/12/2004 16:31 3 006 dbd_xsh.h 14/03/2005 17:45 276 995 DBI.pm 20/01/2005 12:06 137 844 DBI.xs 14/12/2004 16:31 15 329 dbipport.h 14/12/2004 16:31 5 166 dbiprof.PL 26/01/2005 00:57 5 921 dbiproxy.PL 14/12/2004 16:31 2 068 dbivport.h 14/12/2004 16:31 20 902 DBIXS.h 14/12/2004 16:31 3 848 dbi_sql.h 14/12/2004 16:31 18 540 Driver.xst 14/12/2004 16:31 3 422 Driver_xst.h 26/01/2006 09:38 <DIR> ex 26/01/2006 09:36 <DIR> lib 14/12/2004 16:31 10 314 Makefile.PL 14/03/2005 15:44 2 626 MANIFEST 14/03/2005 17:59 336 META.yml 14/12/2004 16:31 1 543 Perl.xs 14/12/2004 16:31 5 135 README 14/12/2004 16:31 15 555 Roadmap.pod 26/01/2006 09:36 <DIR> t 14/12/2004 16:31 5 073 test.pl 14/12/2004 16:31 21 629 ToDo 14/12/2004 16:31 48 typemap 21 fichier(s) 633 570 octets 5 Rép(s) 26 429 689 856 octets libres
C:\pl\tools\DBI\DBI-1.48>perl makefile.pl
*** You are using a perl configured with threading enabled. *** You should be aware that using multiple threads is *** not recommended for production environments.
*** Note: The optional PlRPC-modules (RPC::PlServer etc) are not installed. If you want to use the DBD::Proxy driver and DBI::ProxyServer modules, then you'll need to install the RPC::PlServer, RPC::PlClient, Storable and Net::Daemon modules. The CPAN Bundle::DBI may help you. You can install them any time after installing the DBI. You do *not* need these modules for typical DBI usage.
Optional modules are available from any CPAN mirror, in particular http://search.cpan.org/ http://www.perl.com/CPAN/modules/by-module http://www.perl.org/CPAN/modules/by-module ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module
*** You're using Microsoft Visual C++ compiler but the LIB and INCLUDE environme nt variables are not both set. If you have 'unresolved external symbol' errors during linking, run the vcvars32.bat batch file to set up your LIB and INCLUDE environment variables, and try again. A copy of vcvars32.bat can typically be found in the following directories under your Visual Studio install directory: Visual C++ 6.0: vc98\bin Visual Studio .NET: vc7\bin
Creating DBI::PurePerl test variant: t/zvpp_01basics.t Creating DBI::PurePerl test variant: t/zvpp_02dbidrv.t Creating DBI::PurePerl test variant: t/zvpp_03handle.t Creating DBI::PurePerl test variant: t/zvpp_04mods.t Creating DBI::PurePerl test variant: t/zvpp_05thrclone.t (use threads) Creating DBI::PurePerl test variant: t/zvpp_06attrs.t Creating DBI::PurePerl test variant: t/zvpp_07kids.t Creating DBI::PurePerl test variant: t/zvpp_08keeperr.t Creating DBI::PurePerl test variant: t/zvpp_09trace.t Creating DBI::PurePerl test variant: t/zvpp_10examp.t Creating DBI::PurePerl test variant: t/zvpp_11fetch.t Creating DBI::PurePerl test variant: t/zvpp_14utf8.t Creating DBI::PurePerl test variant: t/zvpp_15array.t Creating DBI::PurePerl test variant: t/zvpp_20meta.t Creating DBI::PurePerl test variant: t/zvpp_30subclass.t Creating DBI::PurePerl test variant: t/zvpp_40profile.t Creating DBI::PurePerl test variant: t/zvpp_41prof_dump.t Creating DBI::PurePerl test variant: t/zvpp_42prof_data.t Creating DBI::PurePerl test variant: t/zvpp_50dbm.t Creating DBI::PurePerl test variant: t/zvpp_60preparse.t Creating DBI::PurePerl test variant: t/zvpp_80proxy.t Checking if your kit is complete... Looks good
I see you're using perl 5.008007 on MSWin32-x86-multi-thread, okay. Remember to actually *read* the README file! Use 'make' to build the software (dmake or nmake on Windows). Then 'make test' to execute self tests. Then 'make install' to install the DBI and then delete this working directory before unpacking and building any DBD::* drivers.
Windows users need to use the correct make command. That may be nmake or dmake depending on which Perl you are using. If using the Win32 ActiveState build then it is recommended that you use the ppm utility to fetch and install a prebuilt DBI instead.
Writing Makefile for DBI
C:\pl\tools\DBI\DBI-1.48>nmake 'nmake' n'est pas reconnu en tant que commande interne ou externe, un programme exécutable ou un fichier de commandes.
C:\pl\tools\DBI\DBI-1.48>dir Le volume dans le lecteur C n'a pas de nom. Le numéro de série du volume est 7883-A83E
Répertoire de C:\pl\tools\DBI\DBI-1.48
26/01/2006 09:41 <DIR> . 26/01/2006 09:41 <DIR> .. 14/03/2005 17:45 78 270 Changes 14/12/2004 16:31 3 006 dbd_xsh.h 14/03/2005 17:45 276 995 DBI.pm 20/01/2005 12:06 137 844 DBI.xs 14/12/2004 16:31 15 329 dbipport.h 14/12/2004 16:31 5 166 dbiprof.PL 26/01/2005 00:57 5 921 dbiproxy.PL 14/12/2004 16:31 2 068 dbivport.h 14/12/2004 16:31 20 902 DBIXS.h 14/12/2004 16:31 3 848 dbi_sql.h 14/12/2004 16:31 18 540 Driver.xst 14/12/2004 16:31 3 422 Driver_xst.h 26/01/2006 09:38 <DIR> ex 26/01/2006 09:36 <DIR> lib 26/01/2006 09:41 38 166 Makefile 14/12/2004 16:31 10 314 Makefile.PL 14/03/2005 15:44 2 626 MANIFEST 14/03/2005 17:59 336 META.yml 14/12/2004 16:31 1 543 Perl.xs 14/12/2004 16:31 5 135 README 14/12/2004 16:31 15 555 Roadmap.pod 26/01/2006 09:41 <DIR> t 14/12/2004 16:31 5 073 test.pl 14/12/2004 16:31 21 629 ToDo 14/12/2004 16:31 48 typemap 22 fichier(s) 671 736 octets 5 Rép(s) 26 429 640 704 octets libres
C:\pl\tools\DBI\DBI-1.48>dmake 'dmake' n'est pas reconnu en tant que commande interne ou externe, un programme exécutable ou un fichier de commandes.
C:\pl\tools\DBI\DBI-1.48>nmake 'nmake' n'est pas reconnu en tant que commande interne ou externe, un programme exécutable ou un fichier de commandes.
C:\pl\tools\DBI\DBI-1.48>make 'make' n'est pas reconnu en tant que commande interne ou externe, un programme exécutable ou un fichier de commandes.
C:\pl\tools\DBI\DBI-1.48>
-- Alexander Foken mailto:alexander@xxxxxxxx http://www.foken.de/alexander/
.
- References:
- got problem with installing DBI
- From: Nizar LAHYANI
- got problem with installing DBI
- Prev by Date: RE: got problem with installing DBI
- Next by Date: have problems in intalling dbi module
- Previous by thread: got problem with installing DBI
- Next by thread: RE: got problem with installing DBI
- Index(es):
Relevant Pages
|
|
