DB2 on As400 ADO.NET compatibality

[Sleepy Smurf]

Hello all,

I wonder if you could clarify this for me:

I want to develop applications on the Visual Studio.Net platform with
connectivity to the DB2 on the AS400 platform for the database.

I have used the Visual Studio 6 platform with the AS/400 platform for the
database happily for the last year using ADO and the OLEDB connectivity.

On my investigations to see the right path to ADO.NET connectivity to the
AS/400 I have spoted the following products (mainly in beta):

- Stinger Technology preview
- DB2 UDB Personal Developer's Edition (V8.1.3).
- The iSeries Access for Windows beta including a new .NET Framework
Data Provider for DB2 Universal Database.

I have installed the DB2 Connect product from the DB2 UDB Personal
Developer's Edition and can connect to the AS/400 from the Windows XP
platform, but from the Visual studion.NET environment I get a connection
failed when trying to add a connection from the DB2 Explorer window.

Am I doing something wrong or missing a step, or is this version of the DB2
connect not compatible with VS.Net.

If anyone has managed to connect to the AS/400 DB2 database from the Windows
platform using the ADO.NET VS.NET environment, could you explain to me how
and what components you used.

Thank you very much for you help.

Sleepy

[Kent Milligan]

I seem to recall that DB2 Connect 8.1 doesn't officially support .NET
connections to iSeries - I think you need to download one of the 2 betas that
you mention.

--
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, iSeries
km***@us.eye-bee-m.com (spam trick) GO HAWKEYES!!

www.iseries.ibm.com/db2

(opinions stated are not necessarily those of my employer)