Hello. I normally use the Table Import Wizard in PowerPivot to get new data. I normally use an OLEDB/ODBC connection to connect to my DB2 database. But when I try to connect to the database through the IBM DB2 connection wizard, I'm getting this error message: "failed to connect to the server. Reason: The 'DB20LEDB' provider is not registered on the local machine." However, I've already set up a driver on my local machine, else I couldn't have been using the OLEDC/ODBC connection to get data from DB2. Any ideas? Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Problem connecting to DB2 server
- Thread starter jk-vtti
- Start date
-
- Tags
- db2 server table import tizard
