System DSNs in Windows 7 RRS feed

  • Question

  • Is it documented somewhere what has changed in Windows 7 when it comes to DSNs.  I spent 2 days trying to get a system dsn to work on a Windows 2000 database.
    In the end, I had to use a User DSN for it to work.  Do I now have to setup DSNs for each user that logs in to the machine?

    Best Regards

    Thursday, December 17, 2009 3:59 PM


All replies

  • You need to download RSAT and install it.

    Remote Server Administration Tools for Windows 7

    After installing, please refer the instructions on the web page to enable ODBC.

    Then, the steps to get DSN are the same.

    HOW TO: Create a System Data Source Name in Windows XP 

    Arthur Xie - MSFT
    • Marked as answer by Arthur Xie Tuesday, December 29, 2009 5:26 AM
    Friday, December 18, 2009 9:11 AM
  • I'm having the same issue. 

    I have RSAT installed but didn't see any documentation on enabling ODBC.  I am able to open the Data Sources tool on my workstation and others, create a system dsn, but it does not allow all users on a Windows 7 (x64) computer to connect to the database.  A user dsn does work.  Any clues?
    • Proposed as answer by Andragoras Wednesday, January 6, 2010 9:12 PM
    Wednesday, January 6, 2010 7:05 PM
  • Same issue for me as well - has anyone found a resolution?
    Monday, February 15, 2010 5:34 PM
  • Same issue... a solution ?????? I really need it to work !!!
    Wednesday, September 15, 2010 1:49 PM
  • Trying using this...


    Francis Ho

    • Proposed as answer by defecta Wednesday, October 31, 2012 7:01 AM
    Tuesday, November 16, 2010 12:19 AM
  • MS Access drivers here:


    This file will add Access to the list of file types in the ODBC administrator.

    Not sure if its 32 or 64 bit. But it worked on a machine running 64bit Win 7

    Francis Ho

    Tuesday, November 16, 2010 12:25 AM
  • I used MS Access to create the ODBC connection to a SQL Server.

    Get to link tables and select the connection on the "MACHINE" tab, not the User Tab.

    I found that if I created the connection through Access instead of the Control panel it actually applied to every user.

    Thursday, November 18, 2010 1:15 AM
  • Thanks Francis!  The answer that worked for me was.


    Looks like the the ODBC console in 32 bit shows up in control panel, but in 64 bit OS it's only showing up in the Administrative Tools section.  Not sure why they didn't put the 32 bit ODBC console in the control panal???  -William

    Richland, WA IT
    Tuesday, March 15, 2011 8:43 PM
  • Thanks for the info seems to have solved my issue.
    Sunday, May 29, 2011 12:20 PM
  • Thanq.......Francis......itz worked..........
    Tuesday, August 21, 2012 7:22 AM
  • Thanks Francis. 

    64-bit machine running 32 bit Excel. Needed the 32bit ODBC application in order to connect

    Monday, January 9, 2017 8:36 PM