asked on
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
connection-error.PNG
Microsoft OfficeDatabases* ODBCMicrosoft Excel
Last Comment
Pavel Celba
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Split points seems to be a good option in the case author is not responding to correct answers.
did you solve the problem already? Please post some status or ask for more help or close the question.
TIA
Pavel