Re: First time DBI user crashing perl

Turning on tracing is usually a good idea when odd things are happening.
Read https://metacpan.org/pod/DBI#TRACING
and set the DBI_TRACE environment variable.

Tim.

On Wed, Oct 29, 2014 at 09:56:27PM -0600, Jon wrote:
>    Hello Peter,
> 
>    Well, that's kinda what I figured but never hurts try for the easy answer.
> 
>    I cleaned up your test script a bit. 
> 
>    Can you give this version a try: [1]https://gist.github.com/three18ti/c37587ef7d5fb9ee5748
> 
>    I'm downloading DB2 as we speak, but I wanted to ask for your DB2_HOME environment variable.  In your
>    instructions it has you set it, but the instructions are clearly for a linux server, what did you do on
>    your windows server?
> 
>    Honestly, I have very limited DB2 experience, so it's kinda the blind leading the blind here.  I'm
>    really just curious myself. you're more than welcome to ignore me and wait for one of the more
>    experienced guys :)
> 
>    Best Regards,
>    Jon A
>    On Wed, Oct 29, 2014 at 8:42 PM, Peter Shabino <[2][email protected]> wrote:
> 
>      I am running it from a command prompt and I am getting some of the output so perl is running fine.
>      Just looks like any command that trys and uses the DB2 interface causes a crash. 
>      Thanks,
>      Peter
> 
>      My projects:
>      [3]http://www.wire2wire.org/
> 
>    --------------------------------------------------------------------------------------------------------
> 
>      Date: Wed, 29 Oct 2014 20:26:15 -0600
>      Subject: RE: First time DBI user crashing perl
>      From: [4][email protected]
>      To: [5][email protected]
>      CC: [6][email protected]
> 
>      Hello Peter,
> 
>      How are you invoking the script? Do you have a perl script that you double click?
> 
>      If so, can you try opening a command/powershell window and running your program? You'll likely have to
>      specify the full path to the perl binary then pass your script as the first parameter.
> 
>      E.g.: \strawberry\perl\bin\perl.exe [7]my_script.pl
> 
>      I have not encountered this particular problem with db2 but this is my first step when trying to get
>      one of my scripts to run in Windows (I'm a Linux enginner by the Windows engineers steal a lot of my
>      applications), perhaps someone has more specific experience than myself.
> 
>      Best Regards,
>      Jon A
> 
>      On Oct 29, 2014 5:50 PM, "Peter Shabino" <[8][email protected]> wrote:
> 
>        Try this again I apparently found a keyboard shortcut to send the message in hotmail......
> 
>        Trying to set up a connection to a remote DB2 server in perl to query some data. 
>        Followed the directions here:
>        [9]http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21297335
>        Then searching the web I came up with this chunk of code:
>        use warnings;
>        use strict;
>        use DBI;
>        use DBD::DB2;
>        print("Operating System = ",$^O,"\n");
>        print("Perl Binary = ",$^X,"\n");
>        print("Perl Version = ",$],"\n");
>        print("DBI Version = ",$DBI::VERSION,"\n");
>        print("DBD::DB2 Version = ",$DBD::DB2::VERSION,"\n\n");
>        print("env = ",$ENV{ DB2INSTANCE},"\n");
>        my @driver_names = DBI->available_drivers;
>        print(join("\n",@driver_names),"\n");
>        print("I am here\n");
>        my @dataSources   =   DBI->data_sources('DB2');
>        print(@dataSources,"\n");
>        print("I am there\n");
>        exit(0);
>        When I run this I get a popup that says the "Perl interpreter has stopped working" and a button to
>        close the program. 
>        on the console I get:
>        Operating System = MSWin32
>        Perl Binary = c:\strawberry\perl\bin\perl.exe
>        Perl Version = 5.018001
>        DBI Version = 1.631
>        DBD::DB2 Version = 1.85
>        env = DB2
>        ADO
>        DB2
>        DBM
>        ExampleP
>        File
>        Gofer
>        ODBC
>        Pg
>        Proxy
>        SQLite
>        Sponge
>        mysql
>        I am here
>        So the failure is when I try and get the DB2 data sources... 
>        Just have no idea even where to start looking for the issue since there is no error message. Is
>        there a log file with more information on what might have died?
>        Thanks,
>        Peter
>        My projects:
>        [10]http://www.wire2wire.org/
> 
> References
> 
>    Visible links
>    1. https://gist.github.com/three18ti/c37587ef7d5fb9ee5748
>    2. mailto:[email protected]
>    3. http://www.wire2wire.org/
>    4. mailto:[email protected]
>    5. mailto:[email protected]
>    6. mailto:[email protected]
>    7. http://my_script.pl/
>    8. mailto:[email protected]
>    9. http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21297335
>   10. http://www.wire2wire.org/