Topic
  • 1 reply
  • Latest Post - ‏2014-06-17T21:44:40Z by Slakshmi
VenkateshNethaG
VenkateshNethaG
1 Post

Pinned topic How to know the Provider name for IBM DB2

‏2013-11-15T07:03:26Z |

I am getting 

"run time error 3706 provider cannot be found it may not be properly installed" error while connecting to IBM BD2

strconn = "Provider=ibmdadb2;server=********;Database=*****;Uid=**;Pwd=***;"

 

Can any one help me, How to know the Provider name for IBM DB 2

 

Am working with Macro VBA application.

 

Thanks in advance

  • Slakshmi
    Slakshmi
    2 Posts

    Re: How to know the Provider name for IBM DB2

    ‏2014-06-17T21:44:40Z  

    ibmdadb2.dll is the IBM DB2 OLEDB provider.

    If you are on DB2 V9.7, you can use Configuration assitant to test OLEDB connection.

    Here is a technote that explains how to register IBMDADB2.

    http://www-01.ibm.com/support/docview.wss?uid=swg21219288

    Thanks!