.NET Provider for DB2 8.2.1

24 Apr 2006 2:30 PM

Rusty

Hi, I need to access a DB2 8.2.1 server on AIX64. Normally we access
SQL Server, but I'd like to go directly to the DB2 server with a web
service if possible.

1) is there an IBM .net data provider? if yes, is this the way to go?
2) does the data provider require me to use a license file or anything?
I have a name & password to the server, but another department owns it.
I'm just a user.
3) any opinions about what I want to do? It's pretty simple, I want to
return 100 rows or fewer in XML via the web service.

If you have a link to any code samples or a download link to the
provider that would help greatly!

Thanks! Rusty.

--
Sent via .NET Newsgroups
http://www.dotnetnewsgroups.com

24 Apr 2006 10:59 PM

Ken North

> 1) is there an IBM .net data provider?

IBM has more than one (depending on which version of DB2 you're
running). Here's a complete list of all companies and open source
projects shipping .NET data providers:
http://www.sqlsummit.com/DataProv.htm

======== Ken North ===========
www.WebServicesSummit.com
www.SQLSummit.com
www.GridSummit.com

25 Apr 2006 8:14 AM

Frans Bouma [C# MVP]

Rusty wrote:

> Hi, I need to access a DB2 8.2.1 server on AIX64. Normally we access
> SQL Server, but I'd like to go directly to the DB2 server with a web
> service if possible.
>
> 1) is there an IBM .net data provider? if yes, is this the way to go?

On AIX, you need the normal provider. Get it either via the IBM
customer downloads or use:
http://www-306.ibm.com/software/data/db2/runtime.html
Though as you're a licensee of DB2 on AIX, I'd contact IBM and get the
direct downloads to the client tools

> 2) does the data provider require me to use a license file or
> anything? I have a name & password to the server, but another
> department owns it. I'm just a user.

No.

> 3) any opinions about what I want to do? It's pretty simple, I want
> to return 100 rows or fewer in XML via the web service.

That's normal db procedure, so it should work fine :)

Frans

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------