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:
    234
    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,275
  3. 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:
    572
    Guest
    Sep 28, 2006
  4. Dave S

    ODBC-Call Failed Office 2007

    Dave S, Nov 30, 2007, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    476
    Dave S
    Nov 30, 2007
  5. 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:
    909
    Floyd Shadwick
    Jun 27, 2008
Loading...

Share This Page