locked
System DSNs in Windows 7 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    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

    Randy
    Thursday, December 17, 2009 3:59 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    Same issue for me as well - has anyone found a resolution?
    Monday, February 15, 2010 5:34 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Same issue... a solution ?????? I really need it to work !!!
    Wednesday, September 15, 2010 1:49 PM
  • Question
    Sign in to vote
    4
    Sign in to vote

    Trying using this...

    c:\windows\sysWOW64\odbcad32.exe

    Francis Ho

    • Proposed as answer by defecta Wednesday, October 31, 2012 7:01 AM
    Tuesday, November 16, 2010 12:19 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    MS Access drivers here:

    http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=e

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Rick
    Thursday, November 18, 2010 1:15 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks Francis!  The answer that worked for me was.

    c:\windows\sysWOW64\odbcad32.exe

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks for the info seems to have solved my issue.
    Sunday, May 29, 2011 12:20 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    Thanq.......Francis......itz worked..........
    Tuesday, August 21, 2012 7:22 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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