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