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"

"DB2" <db2team@hotmail.com> wrote in message
news:a78ec628.0404010819.59686693@posting.google.c om...
> Hi Marcus,
>
> I suggest you try with another ODBC driver, StarSQL
> (www.starquest.com) might be a good option.
>
> Bob
>
>
> marcus.malmgren@plastal.com (Marcus) wrote in message
news:<d4261158.0404010049.42f28640@posting.google. com>...
> > 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