Is the driver you are using the one you used to install the DBD libs with? If you installed the DBD libs with one driver and then, say, upgraded the driver, you would have to re-install the DBD libs.
Carl Furst On 10/30/14, 5:37 PM, "Tim Bunce" <tim.bu...@pobox.com> wrote: >On Thu, Oct 30, 2014 at 03:33:05PM -0500, Peter Shabino wrote: >> Here is the environment variables: >> env DB2INSTANCE = DB2 >> env DB2LIB = C:/Program Files/IBM/SQLLIB/lib/Win32 >> env LD_LIBRARY_PATH = C:/Program Files/IBM/SQLLIB/lib/Win32 >> env LIBPATH = C:/Program Files/IBM/SQLLIB/lib/Win32 >> and the output from trace 15 >> New 'DBI::dr' (for DBD::DB2::dr, parent='', id=undef) >> >>dbih_setup_handle(DBI::dr=HASH(0x2e4c7c0)=>DBI::dr=HASH(0x2e4c868), >>DBD::DB2::dr, 0, Null!) >> dbih_make_com(Null!, 0, DBD::DB2::dr, 176, 0) thr#98a6f8 >> dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), Err, Null!) >>SCALAR(0x2acff18) (already defined) >> dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), State, Null!) >>SCALAR(0x2e11358) (already defined) >> dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), Errstr, Null!) >>SCALAR(0x2acff60) (already defined) >> dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), TraceLevel, Null!) 0 >>(already defined) >> dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), FetchHashKeyName, >>Null!) 'NAME' (already defined) >> <- install_driver= DBI::dr=HASH(0x2e4c7c0) >> >> data_sources DISPATCH (DBI::dr=HASH(0x2e4c7c0) rc1/3 @1 g3 >>ima801 pid#9476) at >> c:/strawberry/perl/site/lib/DBI.pm line 1066 via at db2.pl line 35 >> !! The warn '0' was CLEARED by call to data_sources method >> -> data_sources for DBD::DB2::dr >>(DBI::dr=HASH(0x2e4c7c0)~0x2e4c868) thr#98a6f8 >> Any clues in there on what I have set up wrong? > >Nope. Sure looks like a crash within the DBD::DB2 driver. >Hopefully someone here can help but you could also try >http://www.software.ibm.com/data/db2/perl > >Tim. > >> Here is my perl version >> This is perl 5, version 18, subversion 1 (v5.18.1) built for >>MSWin32-x64-multi-thread >> Thanks! >> Peter >> >> My projects: >> http://www.wire2wire.org/ >> > Date: Thu, 30 Oct 2014 12:17:19 +0000 >> > From: tim.bu...@pobox.com >> > To: three1...@gmail.com >> > CC: wi...@hotmail.com; dbi-users@perl.org >> > Subject: 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]wi...@hotmail.com> 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]three1...@gmail.com >> > > To: [5]wi...@hotmail.com >> > > CC: [6]dbi-users@perl.org >> > > >> > > 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]wi...@hotmail.com> >>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:wi...@hotmail.com >> > > 3. http://www.wire2wire.org/ >> > > 4. mailto:three1...@gmail.com >> > > 5. mailto:wi...@hotmail.com >> > > 6. mailto:dbi-users@perl.org >> > > 7. http://my_script.pl/ >> > > 8. mailto:wi...@hotmail.com >> > > 9. >>http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21297335 >> > > 10. http://www.wire2wire.org/ ********************************************************** MLB.com: Where Baseball is Always On
