Questions

MS Access ODBC on Windows 7

+
0 Votes
Locked

MS Access ODBC on Windows 7

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?
  • +
    0 Votes
    highlander718

    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.

    +
    0 Votes
    HonestBroker

    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?

    +
    0 Votes
    Slayer_

    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"

    +
    0 Votes
    HonestBroker

    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.

  • +
    0 Votes
    highlander718

    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.

    +
    0 Votes
    HonestBroker

    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?

    +
    0 Votes
    Slayer_

    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"

    +
    0 Votes
    HonestBroker

    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.