View Single Post

   
  #1 (permalink)  
Old 02-26-2008, 05:37 PM
Marcus
 
Posts: n/a
Default Connect to AS/400 from .NET

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
Reply With Quote