.NET Provider for DB2 8.2.1

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

 

[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

 

[Frans Bouma [C# MVP]]

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