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)" <greglow@lowell.com.au> wrote in message
news:%23zbUOgCKEHA.3016@tk2msftngp13.phx.gbl...[color=blue]
> Yet another option is to have a local sql server (or msde) and set it up[/color]
as[color=blue]
> a linked server and then just access it via sql server :-)
>
> HTH,
>
> --
> Greg Low (MVP)
> MSDE Manager SQL Tools
>
www.whitebearconsulting.com
>
> "Bill Fahey" <wjfahey@hotmail.com> wrote in message
> news:779e6c65.0404210722.259eb26@posting.google.co m...[color=green]
> > 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" <rich.wallace@minusthecannedmeat.jfsheadotcom> wrote in[/color]
> message news:<e5R7nxCGEHA.1396@TK2MSFTNGP11.phx.gbl>...[color=green][color=darkred]
> > > Here's a conn string I use to get to ours:
> > >
> > > Private Const sConnStr As String =[/color][/color][/color]
"Provider=IBMDA400.DataSource.1;[color=blue]
> " &[color=green][color=darkred]
> > > _
> > > "User ID=zzz;Data Source=sysname;Protection[/color][/color]
> Level=None; "[color=green][color=darkred]
> > > & _
> > > "Transport Product=Client Access; " & _
> > > "Force Translate=00037;Default Collection=zzz; " &[/color][/color][/color]
_[color=blue][color=green][color=darkred]
> > > "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[/color][/color]
> Server.[color=green][color=darkred]
> > > > > 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[/color][/color][/color]
I[color=blue][color=green][color=darkred]
> > > > > don't supply a provider in the connection string, the program[/color][/color][/color]
hangs[color=blue][color=green][color=darkred]
> > > > > saying that a provider is requiered.
> > > > > I have tried using different providers IBMDA400, MSDASQL,[/color][/color][/color]
DB2OLEDB.[color=blue][color=green][color=darkred]
> > > > > 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[/color][/color][/color]
on[color=blue][color=green][color=darkred]
> > > > > 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[/color][/color]
>
>[/color]
