RE: First time DBI user crashing perl

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:
http://www.wire2wire.org/


Date: Wed, 29 Oct 2014 20:26:15 -0600
Subject: RE: First time DBI user crashing perl
From: [email protected]
To: [email protected]
CC: [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 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" <[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: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 = MSWin32Perl Binary = c:\strawberry\perl\bin\perl.exePerl Version = 5.018001DBI Version = 1.631DBD::DB2 Version = 1.85
env = DB2ADODB2DBMExamplePFileGoferODBCPgProxySQLiteSpongemysqlI 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:
http://www.wire2wire.org/