We help IT Professionals succeed at work.
Get Started

DSN connection no longer works after upgrading to excel 2016

111 Views
Last Modified: 2017-12-04
I have been using iseries access odbc drivers to connect excel 2010 to our iseries database. We recently upgraded t excel 2016 and the drivers do not appear to work any more. old reports that i created in 2010 will refresh in the 2016 version and i can edit the definitions with no problem. i just cant get a brand new connection in excel to connect. I get the following error attached. The database i am connecting to is running V6R1. The strange thing is i have another Iseries database that i can still connect to using excel 2016 but it is on version 7R1
connection-error.PNG
Comment
Watch Question
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 2 Answers and 4 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE