Connect to AS/400 from .NET

[Marcus]

Hello!

I'm trying to write a VB.NET program that connects to a AS/400 Server.
I've tried almost everything, but it will not connect.
I've tried to set up a DSN using the Client Access ODBC-driver
(v8.00.04.08) but with no result. I've also tried a DSN-less
connection.
From VB.NET i'm using oleDbConnection to create the connection. If I
don't supply a provider in the connection string, the program hangs
saying that a provider is requiered.
I have tried using different providers IBMDA400, MSDASQL, DB2OLEDB.
Always with the same result: An unhandled exception of type
'System.InvalidOperationException' occurred in system.data.dll

Additional information: The 'IBMDA400' provider is not registered on
the local machine.

How do I register the IBMDA400 provider? Is there an other way to
connect? Is it possible to make a DSN-less connection?

Thanks!
Marcus Malmgren

 

[JB]

ISeries Access for Windows beta provides a .NET Framework Data Provider.
See the URL below

http://www-1.ibm.com/servers/eserver/iseries/access/windows/beta.html

I don't think this beta has gone live. It was updated on Feb 10, 2004.

HTH
JB

 

[DB2]

Hi Marcus,

I suggest you try with another ODBC driver, StarSQL
(www.starquest.com) might be a good option.

Bob

 

[Rich Wallace]

Here's a conn string I use to get to ours:

Private Const sConnStr As String = "Provider=IBMDA400.DataSource.1; " &
_
"User ID=zzz;Data Source=sysname;Protection Level=None; "
& _
"Transport Product=Client Access; " & _
"Force Translate=00037;Default Collection=zzz; " & _
"Convert Date Time To Char=TRUE;Password=xyzzyj"

 

[Bill Fahey]

Marcus,

Another option would be to use an ADO.NET provider to access the
AS/400 instead of the OLE DB option. This would provide better
performance and allow you take advantage of the features in the .NET
framework (security, memory management).

DataDirect's Connect for .NET provides a 100% managed ADO.NET provider
that can access all flavors of DB2, including AS/400. There are also
no dependencies on DB2 database clients. Everything you need to
connect is in the provider as it uses DRDA to communicate with the
database. You can download a trial version from the Connect for .NET
jump page at:

http://www.datadirect.com/products/dotnet/index.ssp

This trial version is fully functional.

Hope this helps.

Bill Fahey
(bill dot fahey at datadirect dot com)

 

[Greg Low \(MVP\)]

Yet another option is to have a local sql server (or msde) and set it up as
a linked server and then just access it via sql server

HTH,

 

[Serge Rielau]

And loose all SQL optimizations because of teh linked access.
Happy joining

 

[Leon Katsnelson]

DB2 "Stinger" version of DB2 Connect provides both a native DB2 .NET Data
Provider to enable programming for ADO.NET interfaces and a set of DB2
add-ins for Visual Studio .NET to make this programming an natural
experience for Visual Studio .NET programmers. It fully supports
connectivity to DB2 for iSeries and building of complete applications
including client components and server objects such as stored procedures and
user defined functions. To get DB2 "Stinger" go to
http://www.ibm.com/db2/stinger and apply.

--
Leon Katsnelson
Manager, DB2 Product Management and Planning

Want to do hands-on DB2 Stinger programming?
Attend Hands-On Programming - DB2 Application Development One Day
Educational Seminar
at the IDUG conference in Orlando on May 9.
http://conferences.idug.org/namerica/2004/edu_seminars.cfm

DB2 Stinger - The buzz of the database industry.
http://www.ibm.com/db2/stinger