DSN connection no longer works after upgrading to excel 2016

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
natevelli2Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pcelbaCommented:
This means your new Excel is not compatible with the V6R1 drivers. The best solution is to upgrade the 6R1 to 7R1. Of course, you may also downgrade the Excel. Do you need any new specific Excel 2016 feature?

Possible problem could be the bit depth. This means 32 bit Excel can use just 32 bit drivers, 64 bit Excel can use 64 bit drivers.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jackie ManIT ManagerCommented:
Your error just says ODBC driver is outdated and Excel 2016 cannot resolve the host and the fields from the host.
0
pcelbaCommented:
Hi natevelli2,

did you solve the problem already? Please post some status or ask for more help or close the question.

TIA
Pavel
0
pcelbaCommented:
Split points seems to be a good option in the case author is not responding to correct answers.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.