• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 29
  • Last Modified:

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
0
HKFuey
Asked:
HKFuey
  • 3
1 Solution
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now