Results 1 to 9 of 9

Thread: ODBC driver

  1. #1
    Join Date
    Jan 2013
    Posts
    5

    Unhappy Unanswered: ODBC driver

    I am having trouble connecting to an Oracle DB via MS Access.

    Windows 7 64 bit
    Office 2010 32 bit
    ODAC 11.2 Release 5 32 bit

    SQLPlus connects to db using TNSNames

    When I run 32 bit ODBC (C:\Windows\System32\odbcad32.exe) no Oracle driver available.

    I previously installed ODAC 11.2 Release 5 (11.2.0.3.20) Xcopy for Windows x64 and I have an Oracle driver driver available via 64 bit ODBC (c:\windows\syswow64\odbcad32.exe) but the 32 bit Access cannot use the 64 bit driver.

    Help anyone? I am going round and round in circles!

    Pretty please

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Problem & solution are external to Oracle.
    If & when ODBC is correctly installed & configured, then Oracle DB will accept the connection request from Access.

    This is an issue between you & Windoze.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2013
    Posts
    5

    Thanks

    Thanks but I figured that was the issue, but how do I resolve it?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Thanks but I figured that was the issue, but how do I resolve it?
    find a WINDOWS Forum where folks know how to configure ODBC & post your problem there
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jan 2013
    Posts
    5
    Windows doesn't provide an odbc driver for oracle anymore, it is provided as part of the oracle install that's why I posted here

  6. #6
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    What is the version of your Oracle database and oracle client software?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  7. #7
    Join Date
    Jan 2013
    Posts
    5
    Not sure what the db version is.

    The instant client is 11.1.0.6

    The issue is that the ODBC driver is not being created even though the exe reports it is installed correctly.
    Attached Thumbnails Attached Thumbnails file1.png   file2.png  

  8. #8
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Have you added the location of the ODBC driver to the path environment variable?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  9. #9
    Join Date
    Jan 2013
    Posts
    5
    Quote Originally Posted by cis_groupie View Post
    Have you added the location of the ODBC driver to the path environment variable?
    Thanks that fixed it, strange that the oracle install didn't do that, it configured everything else.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •