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...dows/beta.html

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

HTH
JB
"Marcus" <ma*************@plastal.com> wrote in message
news:d4**************************@posting.google.c om...

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

[DB2]

Hi Marcus,

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

Bob
ma*************@plastal.com (Marcus) wrote in message news:<d4**************************@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

[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"

"DB2" <db*****@hotmail.com> wrote in message
news:a7**************************@posting.google.c om...

Hi Marcus,

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

Bob
ma*************@plastal.com (Marcus) wrote in message

news:<d4**************************@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

[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)

"Rich Wallace" <ri**********@minusthecannedmeat.jfsheadotcom> wrote in message news:<e5**************@TK2MSFTNGP11.phx.gbl>...

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" <db*****@hotmail.com> wrote in message
news:a7**************************@posting.google.c om...

Hi Marcus,

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

Bob
ma*************@plastal.com (Marcus) wrote in message

news:<d4**************************@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

[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)

"Rich Wallace" <ri**********@minusthecannedmeat.jfsheadotcom> wrote in message news:<e5**************@TK2MSFTNGP11.phx.gbl>...

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" <db*****@hotmail.com> wrote in message
news:a7**************************@posting.google.c om...

Hi Marcus,

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

Bob
ma*************@plastal.com (Marcus) wrote in message

news:<d4**************************@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

[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,

--
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com

"Bill Fahey" <wj*****@hotmail.com> wrote in message
news:77*************************@posting.google.co m...

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)

"Rich Wallace" <ri**********@minusthecannedmeat.jfsheadotcom> wrote in

message news:<e5**************@TK2MSFTNGP11.phx.gbl>...

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" <db*****@hotmail.com> wrote in message
news:a7**************************@posting.google.c om...

Hi Marcus,

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

Bob
ma*************@plastal.com (Marcus) wrote in message

news:<d4**************************@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

[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,

--
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com

"Bill Fahey" <wj*****@hotmail.com> wrote in message
news:77*************************@posting.google.co m...

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)

"Rich Wallace" <ri**********@minusthecannedmeat.jfsheadotcom> wrote in

message news:<e5**************@TK2MSFTNGP11.phx.gbl>...

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" <db*****@hotmail.com> wrote in message
news:a7**************************@posting.google.c om...

Hi Marcus,

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

Bob
ma*************@plastal.com (Marcus) wrote in message

news:<d4**************************@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

[Serge Rielau]

And loose all SQL optimizations because of teh linked access.
Happy joining
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Serge Rielau]

And loose all SQL optimizations because of teh linked access.
Happy joining
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[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...u_seminars.cfm

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

"Greg Low (MVP)" <gr*****@lowell.com.au> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

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,

--
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com

"Bill Fahey" <wj*****@hotmail.com> wrote in message
news:77*************************@posting.google.co m...

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)

"Rich Wallace" <ri**********@minusthecannedmeat.jfsheadotcom> wrote in message news:<e5**************@TK2MSFTNGP11.phx.gbl>...

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" <db*****@hotmail.com> wrote in message
news:a7**************************@posting.google.c om...
> Hi Marcus,
>
> I suggest you try with another ODBC driver, StarSQL
> (www.starquest.com) might be a good option.
>
> Bob
>
>
> ma*************@plastal.com (Marcus) wrote in message
news:<d4**************************@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

[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...u_seminars.cfm

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

"Greg Low (MVP)" <gr*****@lowell.com.au> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

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,

--
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com

"Bill Fahey" <wj*****@hotmail.com> wrote in message
news:77*************************@posting.google.co m...

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)

"Rich Wallace" <ri**********@minusthecannedmeat.jfsheadotcom> wrote in message news:<e5**************@TK2MSFTNGP11.phx.gbl>...

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" <db*****@hotmail.com> wrote in message
news:a7**************************@posting.google.c om...
> Hi Marcus,
>
> I suggest you try with another ODBC driver, StarSQL
> (www.starquest.com) might be a good option.
>
> Bob
>
>
> ma*************@plastal.com (Marcus) wrote in message
news:<d4**************************@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