DB2 connection with Enterprise Library 2.0 DAAB

[ajmastrean]

Folks,

I know the DAAB in EL 2.0 does not have the DB2 connection by default.
I did some extensive searching and have not found anything clear cut on
whether the EL 1.1 DAAB DB2 connection code can be inserted into the EL
2.0 DAAB.

This post in particular was quite vague, but also quite recent...
http://www-128.ibm.com/developerwor...13865276&cat=19&q=enterprise+library#13865276

This thread seems to imply that you can use a generic .NET DB2
provider...
http://www-128.ibm.com/developerwor...reeDisplayType=threadmode1&forum=467#13852213

Has anyone either implemented the 1.1 code into 2.0? or successfully
used a generic connection? I am not extremely well versed in database
access, let alone access through this DAAB, but I am working on it!

Details or links to details would be great. Thanks.

 

[Matt Noonan]

Has anyone either implemented the 1.1 code into 2.0? or successfully
used a generic connection? I am not extremely well versed in database
access, let alone access through this DAAB, but I am working on it!

You might try posting your question on the forum thread below. It's been a
while since I've spoken to the author, but he did the port to DB2 for the
1.1 code, so perhaps he has updated it for 2.0.

http://www.mygenerationsoftware.com/phpbb2/viewtopic.php?t=1753&highlight=ibm

 

[ajmastrean]

I have since been able to connect to a DB2 database with an OleDB
generic connection, as long as I give the provider name...

The App.config section for that connection looks like

<add name="[Connection name]" connectionString="data source=[iSeries
Machine];User
ID=[User];Password=[Password];provider=IBMDA400.DataSource.1;"
providerName="System.Data.OleDb" />

In the Enterprise Library Configuration tool you simply add that
"provider" connection string parameter. I am fairly certain this
connection will work for the basic queries and nonqueries.