On 1/25/07, Brimacomb, Brent <[EMAIL PROTECTED]> wrote:
When attempting to run a program to access a remote DB2 DB, which
resides on a z/Os box, I've receiving the following error: I've
installed DB2 V9 Windows client. Any one have any ideas?
C:\Perl>perl kelen.pl
Operating System = MSWin32
Perl Binary = c:\Perl\bin\perl.exe
Perl Version = 5.008008
DBI Version = 1.53
DBD::DB2 Version = 1.0
DBI connect('DATABASE=USNETAALDSN2; HOSTNAME=dsn2.prdplexa.sabre.com;
PORT=5002;
PROTOCOL=TCPIP; UID=Z156505; PWD=LUVUNIX0;','Z156505',...) failed:
[IBM][CLI Dr
iver] SQL8002N An attempt to connect to a host failed due to a missing
DB2 Conn
ect product or invalid license. SQLSTATE=42968
at kelen.pl line 21
Connection failed with error: [IBM][CLI Driver] SQL8002N An attempt to
connect
to a host failed due to a missing DB2 Connect product or invalid
license. SQLST
ATE=42968
C:\Perl>
Can you connect to the DB without Perl - from that machine? I'm not sure
what you get that you might use to do the testing, but it looks as if you
can't connect period - and Perl + DBI + DBD::DB2 can't connect because you
can't connect period, rather than because there is a problem with DBD::DB2
per se. At the least, that would be my starting point - get Perl + DBI +
DBD::DB2 out of the loop and ensure you can connect to the DB without them.
If you can't, maybe you can go to IBM for support on the installation and
configuration of DB2 Connect - no need to mention DBD::DB2.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include <disclaimer.h>
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
