Office 2016 cannot see my ODBC connection

Excel 2016 cannot see the SQL ODBC connection I set up. (Data\From Other sources\Microsoft Query)
I have tried setting up in:
control panel\admin\odbc
C:\windows\syswow64\odbcadmin

I had a look in C:\Windows\System32 but I cannot edit the data sources I see there.

64 bit Office 2016, 64 Bit Windows 10 PC
HKFueyAsked:
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.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
You sure Office is 64 bit?

  If so, I would setup a system DSN.  Also name it with    _64    as a suffix to help troubleshoot what's going on.

Jim.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
and although it sounds like you are aware of the 32 / 64 bit versions of the ODBC admin applet, there are some other gotcha's:

https://support.microsoft.com/en-us/help/942976/odbc-administrator-tool-displays-both-the-32-bit-and-the-64-bit-user-d

Jim.
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
HKFueyAuthor Commented:
Ok, thanks for the input. Unfortunately did not have the chance to test yet as the tech installing the PC switched back to 32 bit Office (the ODBC then worked)
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
OK.    We probably could have deleted this then, but I'm pretty sure I wasn't off as far as an answer.

  The ODBC applet setup is very confusing, especially given that the 32 and 64 bit versions are both Odbcad32.exe (just in different directories), and that both display all user DSN's, but only their specific "bitness" on the other types.

For anyone reading this in the future, to recap:

1. Always create a system DSN.
2. Suffix the DSN name with _32 or _64 so you can tell them apart.
3. Realize that there are two applets, one in \SysWOW64 (32 bit) and one in \System32 (64 bit), and that you get the 64 bit version when starting from control panel.

That usually helps you wade through the problem.

Jim.
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.