RE: DB2 UDB connection failed

Steve,

If all you are trying to do is connect .NET to your AS400, the easy way
is the new .NET provider that comes with iSeries Access V5R3.  We are
using it for all of our .NET applications even though our iSeries itself
is still at V5R2.  The ODBC driver will work as well, we used that
before the new provider became available.

Regards,

Jim

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Colin Williams
Sent: Friday, April 01, 2005 8:15 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: DB2 UDB connection failed

Steve,

To connect your .net applications to the 400, I think you will need the
relevant database driver, presumably an ODBC driver. Im think Client
Access comes with an ODBC driver, but knowing zilch about .net, don't
know if that's compatible  

cheers
Colin.W

http://as400blog.blogspot.com
 
Extension   5800
Direct dial   0870 429 5800


-----Original Message-----
From: Steve Richter [mailto:stephenrichter@xxxxxxxxx]
Sent: 01 April 2005 14:44
To: Midrange Systems Technical Discussion
Subject: DB2 UDB connection failed


I have downloaded DB2 universal database to my windows 2000 PC.  The
plan
being to use it to connect my .NET applications to the as400 database.

http://www-306.ibm.com/software/data/db2/udb/

I am getting an error when I test the connection to the as400: 

CLI connection failed.
SQL8002N  Connect processing failed; a valid product license was not
found.
SQLSTATE=42968

I have a valid license for v5r1, 5722ss1, 5050 on my system.  But
apparantly, I need a license for something else.

I called the Boulder license key center and the friendly people there
said
they can give me a temporary key, but they dont know which product I
need to
be licensed to.

That is the question.  What as400 product and feature is needed for DB2
to
be able to connect from the PC to the AS400?

thanks,

-Steve
-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

This e-mail has been sent by a company of Bertram Group Ltd, whose
registered office is 1 Broadland Business Park, Norwich, NR7 0WF. 
This message, and any attachments, are intended solely for the addressee
and may contain privileged or confidential information.  If you are not
the intended recipient, any disclosure, copying, distribution or any
action taken or omitted to be taken in reliance on it, is prohibited and
may be unlawful.  If you believe that you have received this email in
error, please contact the sender immediately. Opinions, conclusions and
statements of intent in this e-mail are those of the sender and will not
bind a Bertram Group Ltd company unless confirmed in writing by a
director independently of this message. 
Although we have taken steps to ensure that this email and any
attachments are free from any virus, we advise that in keeping with good
computing practice the recipient should ensure they are actually virus
free.

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.