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=71uid=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=71uid=swg21297335
10. http://www.wire2wire.org/
RE: First time DBI user crashing perl
Here is the environment variables:
env DB2INSTANCE = DB2env DB2LIB = C:/Program Files/IBM/SQLLIB/lib/Win32env
LD_LIBRARY_PATH = C:/Program Files/IBM/SQLLIB/lib/Win32env 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#98a6f8dbih_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?
Here is my perl versionThis 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 +
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=71uid=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
Re: First time DBI user crashing perl
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 + 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=71uid=swg21297335 Then searching the web I came up with this chunk of code: use
Re: First time DBI user crashing perl
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 + 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
Re: First time DBI user crashing perl
On Oct 30, 2014, at 2:44 PM, Furst, Carl carl.fu...@mlb.com wrote: 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. Also, I don’t know about DB2, and less about Strawberry perl :-/ but I do know a very common issue with is bitness mismatch in the database vendor drivers; 32-bit database driver vs 64-bit perl and vice versa, although there are usually install time errors that will signal this. -- Bruce Johnson University of Arizona College of Pharmacy Information Technology Group Institutions do not have opinions, merely customs
RE: First time DBI user crashing perl
Yea have seen the bitness issue mentioned a bunch. Been very careful to select the 64 bit version of everything. Only questionable items are DBI (cpan DBI) and DBD::DB2 (cpan DBD::DB2) Is there some special flag I need to set or different package name for the 64 bit versions of those 2? Have another note types up with everything I just did (full uninstall and reinstall) and the new error I hit. Thanks,Peter My projects: http://www.wire2wire.org/ From: john...@pharmacy.arizona.edu CC: dbi-users@perl.org Subject: Re: First time DBI user crashing perl Date: Thu, 30 Oct 2014 22:08:55 + On Oct 30, 2014, at 2:44 PM, Furst, Carl carl.fu...@mlb.com wrote: 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. Also, I don’t know about DB2, and less about Strawberry perl :-/ but I do know a very common issue with is bitness mismatch in the database vendor drivers; 32-bit database driver vs 64-bit perl and vice versa, although there are usually install time errors that will signal this. -- Bruce Johnson University of Arizona College of Pharmacy Information Technology Group Institutions do not have opinions, merely customs
FW: First time DBI user crashing perl
/IBMDAT~1/include/sqlext.h:1919:5: error: unknown type name '__out_opt' __out_opt ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1921:5: error: unknown type name '__out_opt' __out_opt ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1926:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchPkCatalogName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1929:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchPkSchemaName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1932:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchPkTableName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1935:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchFkCatalogName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1938:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchFkSchemaName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1941:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchFkTableName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1951:5: error: unknown type name '__in_ecount' __in_ecount(cchSqlStrIn) SQLCHAR* szSqlStrIn, ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1953:5: error: unknown type name '__out_ecount_opt' __out_ecount_opt(cchSqlStrMax) SQLCHAR* szSqlStr, ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1960:5: error: unknown type name '__out_opt' __out_opt ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1970:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchCatalogName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1973:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchSchemaName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1976:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchTableName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1982:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchCatalogName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1985:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchSchemaName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1988:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchProcName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1991:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchColumnName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:1997:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchCatalogName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:2000:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchSchemaName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:2003:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchProcName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:2017:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchCatalogName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:2020:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchSchemaName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:2023:5: error: unknown type name '__in_ecount_opt' __in_ecount_opt(cchTableName) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:2030:5: error: unknown type name '__out_ecount_opt' __out_ecount_opt(cchDriverDescMax) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:2033:5: error: unknown type name '__out_opt' __out_opt ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:2035:5: error: unknown type name '__out_ecount_opt' __out_ecount_opt(cchDrvrAttrMax) ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:2038:5: error: unknown type name '__out_opt' __out_opt ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:2086:5: error: unknown type name '__out' __out ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:2127:5: error: unknown type name '__in_opt' __in_optLPWSTR szFileName, ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:2128:5: error: unknown type name '__out_bcount_opt' __out_bcount_opt(cbOutputMsg) LPWSTR lpwszOutputMsg, ^C:/PROGRA~1/IBM/IBMDAT~1/include/sqlext.h:2129:5: error: unknown type name '__in' __inDWORD cbOutputMsg ^dmake: Error code 129, while making 'Constants.o'dmake.exe: Error code 255, while making 'subdirs' IBMTORDB2/DBD-DB2-1.85.tar.gz C:\STRAWB~1\c\bin\dmake.exe -- NOT OKStopping: 'install' failed for 'DBD::DB2'. Any ideas where I went wrong? Thanks, Peter My projects: http://www.wire2wire.org/ From: carl.fu...@mlb.com To: tim.bu...@pobox.com; wi...@hotmail.com CC: dbi-users@perl.org Subject: Re: First time DBI user crashing perl Date: Thu, 30 Oct 2014 21:44:48 + 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
First time DBI user crashing perl
Trying to set up a connection to a remote DB2 server in perl to query some data. Followed the directions here: My projects: http://www.wire2wire.org/
RE: First time DBI user crashing perl
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=71uid=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/
RE: First time DBI user crashing perl
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 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:
http://www-01.ibm.com/support/docview.wss?rs=71uid=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/
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: three1...@gmail.com
To: wi...@hotmail.com
CC: 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 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 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:http://www-01.ibm.com/support/docview.wss?rs=71uid=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/
Re: First time DBI user crashing perl
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 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:
http://www.wire2wire.org/
--
Date: Wed, 29 Oct 2014 20:26:15 -0600
Subject: RE: First time DBI user crashing perl
From: three1...@gmail.com
To: wi...@hotmail.com
CC: 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 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 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:
http://www-01.ibm.com/support/docview.wss?rs=71uid=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/
