Oracle ODBC driver and Vista

Discussion in 'Windows Vista General Discussion' started by magick, Aug 7, 2007.

  1. magick

    magick Guest

    i have installed the oracle odbc drivers hundreds of times on Windows XP
    machines, but cannot get it to work in Vista. A test connection works in the
    ODBC Administrator, but I get an ODBC call-failed message when trying to
    connect from within my Microsoft Access database.
     
    magick, Aug 7, 2007
    #1
    1. Advertisements

  2. i have installed the oracle odbc drivers hundreds of times on Windows XP
    Hi Magick,

    There are many possible pitfalls. The best pace to ask would really be the
    Oracle ODBC forum: there are many more folks there using Vista with Oracle,
    than there are here:

    http://forums.oracle.com/forums/forum.jspa?forumID=145

    You can read the forum as guest or get an OTN login to post, if you don't
    already have one.

    To get a good response, you'll need to state exactly which version of the
    Driver you are using: eg 9.0.2.8, 10.1.0.5.0, 10.2.0.2.0 etc. You can
    download the latest drivers for Oracle 9 and 10, here:
    http://www.oracle.com/technology/software/tech/windows/odbc/index.html
    For best Vista compatibility, you'd want to run the latest appropriate
    version of the driver.

    To get more precise information about the error, run an ODBC trace while you
    reproduce the problem in Access:
    - run ODBC Administrator;
    - select the Tracing tab;
    - check the "Machine Wide tracing for all user identities, if you run Access
    as a different user;
    - specify a log file location if you like, or accept the default;
    - press Start Tracing now button
    - alt-tab to Access, reproduce your failed ODBC call to Oracle;
    - observe the point of failure;
    - alt-tab back to ODBC Administrator
    - press Stop Tracing Now button.

    Now examine the resulting log file. It's a plain text file and ca be opened
    with Notepad etc. Typically you will find some specific ODBC call which has
    failed. You may see messages like "SQLSTATE 08004". Any SQLSTATE other than
    00000 is an error. There could be other error messages as well. Even if the
    error codes don't mean much to you, they'll mean a lot to an ODBC expert. An
    ODBC call could fail in thousands of different ways, so you want to narrow
    down the scope of the problem as much as possible.

    Hope this helps a bit,
     
    Andrew McLaren, Aug 7, 2007
    #2
    1. Advertisements

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.