No DSN in ODBC Data Source Admin


  1. Posts : 1
    Windows 7 Pro
       #1

    No DSN in ODBC Data Source Admin


    I have a new HP 6200 small form factor that came pre-installed with Windows 7 64bit. I installed our corporate copy of MS Office Pro 2003 and then installed UPS Worldship 2011, which requires an ODBC to connect to our Access database.

    When I go into the ODBC to set up the connection under System DSN, it's completely blank. No Access DSN, no Excel DSN, completely blank. If I try to ADD a DSN the only options shown are SQL DSNs which I can not use.

    Initially, I called UPS Worldship Support. They referred me to Microsoft. After nearly 2 hrs on the phone with MS, they told me to call HP since HP preinstalled the Windows 7 and they handle any software/warranty issues.

    So, I called HP. Their support is the pits. Nobody I talked with even knew what a DSN is (they kept telling me it was DNS not DSN and they are 2 different things!!). Then, they suggested I call Microsoft and PAY to have them help me.

    This is a brand new PC and it's a Windows 7 issue, not Worldship, not hardware, yet I can get any help.

    I've tried some of the options on the various forum (running the 32 bit.exe, copying files, etc) and nothing has worked.

    Anyone have any ideas HOW I can get the Access and Excel DSNs in the ODBC Manager? I need help asap as this is a critical PC to our shipping area. Without it, we are unable to ship via UPS and losing $$$.

    Thanks for any suggestions because I'm fed up with Microsoft AND HP!!!
      My Computer


  2. Posts : 3,009
    Windows 7 Home Premium 64bit
       #2

    Hello tandrews, welcome to the forum.

    First, let me say that the subject of your query is not actually in my knowledge base, However, in an effort to assist I did a search and thought I would offer the following:
    ODBC: frequently asked questions

    here:
    Step-by-step guide on how to set up DSN in ODBC Data Source Administrator on Windows.

    and here:
    MySQL :: MySQL 5.0 Reference Manual :: 19.1.4.3 Configuring a Connector/ODBC DSN on Windows


    Hopefully something in there might help. :)
      My Computer


  3. Posts : 1
    window 7 basic 64 bit
       #3

    JdbcOdbc Dsn connection for Window 7 64 bit machine


    follow the following step;
    right click on data source (odbc) under administrative tool
    go to the properties.and change the following things
    target :%SystemRoot%\SysWOW64\odbccad32.exe
    start in :%SystemRoot%\SysWOW64
    press ander and as admin
    regards
    anurag Upadhyay(india)
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 11:37.
Find Us