On 64bit MS2003 server we cannot get MS-Office to conn with ODBC

Discussion in 'Microsoft Access External Data' started by Philip, Feb 13, 2009.

  1. Philip

    Philip Guest

    We're running a win server std 2003 64bit.
    Trying to connect Access 2007 via ODBC to oracle DB.

    From "MS ODBC Administrator" we can test connect to the remote oracle DB
    From Oracle SQL-net we can connect to the remote oracle DB

    So Oracle tnsnames ... are functional and working.
    But when we try to setup a ODBC link from MS-Access & Excel connection
    fails with
    "Drivers SQLsetconnectAttr failed"

    On the net there's numerous people with the same problem but there's no
    resolution or work around.

    Closest:
    The 32-bit version of the Odbcad32.exe file is located in the
    %systemdrive%\Windows\SysWoW64 folder.
    The 64-bit version of the Odbcad32.exe file is located in the
    %systemdrive%\Windows\System32 folder.

    But how do I get Office to use the 64-bit version of the Odbcad32.exe file
    located in the %systemdrive%\Windows\System32 folder?

    I need urgent help here please?
     
    Philip, Feb 13, 2009
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Brenda Bell

    Need help with ODBC/Jet incompatibilites on NT/Office 97

    Brenda Bell, Sep 19, 2003, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    254
    Brenda Bell
    Sep 19, 2003
  2. Guest

    ODBC: link from MS SQL Server to Access 2000, change of server

    Guest, Dec 29, 2003, in forum: Microsoft Access External Data
    Replies:
    3
    Views:
    1,445
  3. Guest

    Get external data, link tables ODBC stopped working

    Guest, Dec 9, 2005, in forum: Microsoft Access External Data
    Replies:
    5
    Views:
    574
    Guest
    Oct 19, 2006
  4. Guest

    Can't Get to ODBC data sources in Access 2003

    Guest, Sep 4, 2006, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    462
    Guest
    Sep 4, 2006
  5. Guest

    Access link ODBC to SQL table,path to ODBC -recent install?

    Guest, Sep 28, 2006, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    671
    Guest
    Sep 28, 2006
  6. brinky

    get external data odbc limitation?

    brinky, Feb 13, 2007, in forum: Microsoft Access External Data
    Replies:
    7
    Views:
    496
    Aaron Kempf
    May 2, 2007
  7. Dave S

    ODBC-Call Failed Office 2007

    Dave S, Nov 30, 2007, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    543
    Dave S
    Nov 30, 2007
  8. Floyd Shadwick

    Reloading Excel ODBC driver for Office 2007 on Server 2003 64 bit

    Floyd Shadwick, Jun 27, 2008, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    970
    Floyd Shadwick
    Jun 27, 2008
Loading...