Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

DBD-mysql installation on win7 64-bit

by dxxd116 (Beadle)
on Sep 19, 2012 at 03:27 UTC ( #994400=perlquestion: print w/ replies, xml ) Need Help??
dxxd116 has asked for the wisdom of the Perl Monks concerning the following question:

Hey, Monks: I used "ppm install DBD-Mysql" to install the module. Even though the console show the installation is successful. When I tested it, it simply does not work as expected(Failing to connect to the database). However, I can install and DBD-MysqlPP correctly and get it work as expected. Please advise what to do in this case.

My "perl -V" produce the following:

Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Users\cai xingliang>ppm uninstall dbd::mysql DBD-mysql: uninstalled C:\Users\cai xingliang>ppm install dbd-mysql Downloading DBD-mysql-4.022...done Unpacking DBD-mysql-4.022...done Generating HTML for DBD-mysql-4.022...done Updating files in site area...done 12 files installed C:\Users\cai xingliang>cd /d d:/study/perl/test d:\study\perl\test>dbi.pl Database alive!1348024795 Database alive!1348024795 $VAR1 = bless( {}, 'DBI::db' ); DBI::db $VAR1 = bless( {}, 'DBI::db' ); Database alive!1348024795 d:\study\perl\test>dbi.pl Reconnecting to mysql server... Reconnecting to mysql server... Reconnecting to mysql server... Terminating on signal SIGINT(2) d:\study\perl\test>perl -V Summary of my perl5 (revision 5 version 16 subversion 0) configuration +: Platform: osname=MSWin32, osvers=5.2, archname=MSWin32-x64-multi-thread uname='' config_args='undef' hint=recommended, useposix=true, d_sigaction=undef useithreads=define, usemultiplicity=define useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=und +ef use64bitint=define, use64bitall=undef, uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='cl', ccflags ='-nologo -GF -W3 -MD -Zi -DNDEBUG -Ox -GL -fp:pr +ecise -DWIN32 -D_CONSOLE -DNO_STRICT -DWIN64 -DCON SERVATIVE -DPERL_TEXTMODE_SCRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_ +CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO', optimize='-MD -Zi -DNDEBUG -Ox -GL -fp:precise', cppflags='-DWIN32' ccversion='14.00.40310.41', gccversion='', gccosandvers='' intsize=4, longsize=4, ptrsize=8, doublesize=8, byteorder=12345678 d_longlong=undef, longlongsize=8, d_longdbl=define, longdblsize=8 ivtype='__int64', ivsize=8, nvtype='double', nvsize=8, Off_t='__in +t64', lseeksize=8 alignbytes=8, prototype=define Linker and Libraries: ld='link', ldflags ='-nologo -nodefaultlib -debug -opt:ref,icf -lt +cg -libpath:"C:\Perl\lib\CORE" -machine:AMD64' libpth=\lib libs=oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib +comdlg32.lib advapi32.lib shell32.lib ole32.lib ol eaut32.lib netapi32.lib uuid.lib ws2_32.lib mpr.lib winmm.lib versio +n.lib odbc32.lib odbccp32.lib comctl32.lib buffero verflowU.lib msvcrt.lib perllibs=oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.l +ib comdlg32.lib advapi32.lib shell32.lib ole32.li b oleaut32.lib netapi32.lib uuid.lib ws2_32.lib mpr.lib winmm.lib ve +rsion.lib odbc32.lib odbccp32.lib comctl32.lib buf feroverflowU.lib msvcrt.lib libc=msvcrt.lib, so=dll, useshrplib=true, libperl=perl516.lib gnulibc_version='' Dynamic Linking: dlsrc=dl_win32.xs, dlext=dll, d_dlsymun=undef, ccdlflags=' ' cccdlflags=' ', lddlflags='-dll -nologo -nodefaultlib -debug -opt: +ref,icf -ltcg -libpath:"C:\Perl\lib\CORE" -machi ne:AMD64' Characteristics of this binary (from libperl): Compile-time options: HAS_TIMES HAVE_INTERP_INTERN MULTIPLICITY PERLIO_LAYERS PERL_DONT_CREATE_GVSV PERL_IMPLICIT_CONTEXT PERL_IMPLICIT_SYS PERL_MALLOC_WRAP PERL_PRESERVE_IVUV PL_OP_SLAB +_ALLOC USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES USE_LOCALE USE_LOCALE_COLLATE USE_LOCALE_CTYPE USE_LOCALE_NUMERIC USE_PERLIO USE_PERL_ATOF USE_SITECUSTOMIZE Locally applied patches: ActivePerl Build 1600 [295879] Built under MSWin32 Compiled at Jun 11 2012 12:05:31 @INC: C:/Perl/site/lib C:/Perl/lib . d:\study\perl\test>

Comment on DBD-mysql installation on win7 64-bit
Download Code
Re: DBD-mysql installation on win7 64-bit
by Anonymous Monk on Sep 20, 2012 at 07:02 UTC
    Try increasing verbosity, use  DBI->trace(2);
      I upgrade to the latest version of PERL 5.16.1. Then the problem is solved. Thank you any way.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://994400]
Approved by Jim
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (6)
As of 2015-07-03 08:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (49 votes), past polls