The 'IBMDADB2.1' provider is not registered on the local machine

Today I was fighthing with an error when I was trying to execute a query against a DB2 database.

I was using IIS 7.5 and the applications seemed to be working fine but when the application needed to execute a query, it throwed that error!

"The 'IBMDADB2.1' provider is not registered on the local machine"

I, as you probably did, google it and found some good tips but no one solve my issue. Some involved to register the dll, to give permissions for IUSR in a IBM/... folder, etc. but it was still failing.

Finally, I realized the application was using the defaul Application Pool for ASP.NET 2.0 applications and then I found the bug!

IBMDADB2.1 was installed as a 32 bits application, so I have to set Enable 32-bit Applications to True for the website application pool/Advance Settings... and that's it!

Hope this help you and save you some time!


PS: A beter solution could be to install IBMDADB2.1 for 64 bits but it was not my case (I was not able to install it)

¡Bienvenidos!

Hola.

Bienvenidos a este blog en donde quisiera compartir aspectos técnicos que pueda ir aprendiendo día a día así como practicar un poco mi inglés, por lo que algunos artículos serán en español y otros en inglés.

Principalmente mi objetivo es colaborar con gente que tenga poco o esté aprendiendo a programar más que ayudar a programadores expertos, aunque si en algo les puedo ayudar, genial.

Mi experiencia no es mucha en desarrollo, solo unos cuantos años en desarrollo web, pero lo que pueda aprender se los pienso compartir.

Gracias por tomarse un tiempo y visitar el blog.

¡Espero irlo mejorando poco a poco! (no sean muy duros conmigo)