DB2 database

[Hambi]

Hi all!

I want to connect IBM DB2 database with System.Data.OleDb.OleDbConnection(). I use connection string "Provider=DB2OLEDB;Database=DBName; User ID=user; Password=pwd" and I get an error "The 'DB2OLEDB' provider is not registered on the local machine.". OK I get it: but how/where can I get this provider OR is another way to connet DB2 in .NET.

Tnx for helping me!

[CPCericola]

If you have an ODBC driver for it, Microsoft has released ODBC.net. I've worked with it a bit and I'm not overly thrilled with it, but it may be worth a shot.

http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?url=/msdn-files/027/001/668/msdncompositedoc.xml