Question

  • Creator
    Topic
  • #2171086

    MS Access ODBC on Windows 7

    Locked

    by honestbroker ·

    A colleague who has an MS access application that connects via ODBC to an Oracle database, recently had their laptop upgraded to Windows 7.
    The company sys admin logged on remotely, installed an Oracle Client and set up a System DSN. In the ODBC configuration dialog box, the support guy clicked on the Test Connection, entered the credentials and got “Test Successful”.
    How can this DSN be made available to my non-admin colleague and the MS access application that needs it?

All Answers

  • Author
    Replies
    • #2887165

      Clarifications

      by honestbroker ·

      In reply to MS Access ODBC on Windows 7

      Clarifications

    • #2887160

      workaround ?

      by highlander718 ·

      In reply to MS Access ODBC on Windows 7

      not sure why your non-admin colleague is not seing the System DSN, but a workaround might be to setup a user DSN. Do you have WinNT authentication on the Oracle machine ? Because in that case it is even better to use User DSN.

      • #2887157

        Reponse To Answer

        by honestbroker ·

        In reply to workaround ?

        Very useful suggestion! the non-admin user can create a User DSN and when they Test Connection -> “Test Successful”!
        However in MS Access, when creating the ODBC linkage it returns with “ODBC–call failed”. Not very informative eh?
        I suppose that now we know it is an MS-Access specific issue – should I re-post elsewhere as an MS-Access query?

    • #2887144

      Is it a 64 bit machine?

      by slayer_ ·

      In reply to MS Access ODBC on Windows 7

      If so, check if access is running in 32 bit mode. Look in task manager and see if beside the process, does it say *32. If so. The ODBC in the control panel won’t work, you have to set the 32 bit version. Located here “C:\windows\SysWOW64\odbcad32.exe”

      • #2887762

        Reponse To Answer

        by honestbroker ·

        In reply to Is it a 64 bit machine?

        I just got to check the system now and it is in fact the System Type is 32-bit Operating System and only one odbcad32.exe installed.

Viewing 2 reply threads