Script failing while using PREPARE.

Hi All,

I am using a perl script to execute a SQL from windows by using a CYGWIN tool which executes the script on a unix server. When I do so by logging into the server and executing the script the script runs fine.But when I do so using cygwin from windows the connect statement works fine but the prepare statement fails with the following error:

dbih_setup_handle(DBI::st=HASH(0x82af484o)=>DBI::st=HASH(0x814fcc4), DBD::ODB
C::st, 82af490, Null!)
dbih_make_com(DBI::db=HASH(0x82af400), 82af798, DBD::ODBC::st, 208, 0) thr#8
14f008
<> DESTROY ignored for outer handle DBI::st=HASH(0x82af484) (inner DBI::st=H
ASH(0x814fcc4) has ref cnt 1)
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x814fcc4)~INNER) thr#814f008
Statement handle DBI::st=HASH(0x814fcc4) DESTROY ignored - never set up
ERROR: -2 '(DBD: st_prepare/SQLPrepare err=-2)'
<- DESTROY= undef at ppp.pl line 16
!! ERROR: -2 '(DBD: st_prepare/SQLPrepare err=-2)'
<- prepare= undef at ppp.pl line 16


My script name is ppp.pl.

Please advice.

Regards,
Pijush


________________________________
DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.

Relevant Pages

  • Re: TERM::ReadLine and program flow question
    ... on the off chance that my 'default' sub turns up returning undef ... an undef value, which the sub converts to '' .. ... that's all fine and dandy but I don't want to make the user re-run the ... script several times whenever he supplies bad input. ...
    (perl.beginners)
  • Re: Clash between DBI/Oracle::DBD and SOAP::Lite
    ... Duncan Garland wrote: ... We've got a script which segmentation faults whenever we try to use both DBI and SOAP::Lite. ... 'HTTP::Request=HASH', undef, undef, undef, 180) called at ... *Perl Programmer* ...
    (perl.dbi.users)
  • Clash between DBI/Oracle::DBD and SOAP::Lite
    ... We've got a script which segmentation faults whenever we try to use both DBI and SOAP::Lite. ... 'HTTP::Request=HASH', undef, undef, undef, 180) called at ... When the call to connect to Oracle is commented out, ... *Perl Programmer* ...
    (perl.dbi.users)
  • Re: Missing documentation for HAVE_FOOBAR definitions
    ... I have a file config.h.in which contains a load #undef HAVE_FOO macros. ... config.h.in is created by autoheader. ... config.h is not generated directly by the configure script, ... "not a good idea" I mean it will cause frustration and possible ...
    (comp.os.linux.development.apps)
  • Re: DBD::CSV malfunction?
    ... Use of uninitialized value in concatenation or string at ... I tried your script and I agree, I can't quite seem to get it to work ... It seems to have an issue reading the column headings from ... 'escape_char' => undef, ...
    (comp.lang.perl.misc)