How to install Oracle ODBC Driver (for Microsoft Addess)

Hi Alex,

tx for writing

win32_11gr2    
windows xp  32

tx, s

tx Alex.. will try it.... will get back you tomm

tx, sandra

Hi Alex,

i downloaded driver now

and did a shut down

just checked the odbc list ... and Oracle ODBC does not show

if any idea, pls advise, tx, sandra

i downloaded driver now

did you actually install it?!

Hi Alex...

yes, to answer above, did install odbc driver


ok, so i tried to uninstall oracle client.... here are the screen shots

it had me a run a deinstall command in the dos/run window... some .net stuff was removed

yet, if i go to programs/start, it's still in there

Maybe removing is more complicated, am not completely understanding the instructions here:

http://docs.oracle.com/cd/B28359_01/install.111/b32007/deinstall.htm#i1008427

Can i just install the instant files "on top" of what my pc has now?

pls advise, tx, sandra

Hi Alex,

yes, i double clicked on the bat file.... it's running again now

it removes some stuff

i suspect due to the link that i pasted above from Oracle that it does not remove officially from start/programs..... it's still under start/programs

i was watching it now... it said Installer cleanup completed with errors and then the dos screen closed

it did remove some windows and .net components, though

tx, sandra

I was reading the run/dos window and they talked about a log file being created from uninstall

so this is the text file that i found in this folder:

C:\Program Files\Oracle\Inventory\logs

tx Alex!

text file:


INFO: Environment Variables:

INFO:       ORACLE_HOME =

INFO:       PATH = C:\DOCUME~1\tfeinzei\LOCALS~1\Temp\OraDeinstall2014-01-09_10-57-41\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem

INFO:       CLASSPATH = .;C:\Program Files\QuickTime\QTSystem\QTJava.zip

INFO: Username:tfeinzei

INFO: Install area Control created with access level  0

INFO: Creating a new Install area Control for this inventory session with new  access level  0

INFO: Install area Control created with access level  0

INFO: Creating a new Install area Control for this inventory session with new  access level  0

INFO: Install area Control created with access level  0

INFO: Creating a new Install area Control for this inventory session with new  access level  0

INFO: Install area Control created with access level  0

INFO: Creating a new Install area Control for this inventory session with new  access level  0

INFO: Install area Control created with access level  0

INFO: Creating a new Install area Control for this inventory session with new  access level  0

INFO: Install area Control created with access level  0

INFO: Creating a new Install area Control for this inventory session with new  access level  0

INFO: Install area Control created with access level  0

INFO: Creating a new Install area Control for this inventory session with new  access level  0

INFO: Install area Control created with access level  0

INFO: Creating a new Install area Control for this inventory session with new  access level  0

INFO: Install area Control created with access level  0

INFO: Creating a new Install area Control for this inventory session with new  access level  0

INFO: Install area Control created with access level  0

INFO: Creating a new Install area Control for this inventory session with new  access level  0

INFO: Install area Control created with access level  2

INFO: Creating a new Install area Control for this inventory session with new  access level  2

INFO: Install area Control created with access level  2

INFO: Creating a new Install area Control for this inventory session with new  access level  2

INFO: Install area Control created with access level  2

INFO: Creating a new Install area Control for this inventory session with new  access level  2

INFO: Setting variable 'ORACLE_HOME' to 'E:\app\tfeinzei\product\11.2.0\client_1'. Received the value from the command line.

INFO: Setting variable 'ORACLE_BASE' to 'E:\app\tfeinzei'. Received the value from the command line.

INFO: Setting variable 'LOCAL_NODE' to 'STUAB010114DX07'. Received the value from the command line.

INFO: Done creating session context and setting session variables as per command line

INFO: RemoveHomeExcludeList is: C:/DOCUME~1/tfeinzei/LOCALS~1/Temp/OraInstall2014-01-09_10-59-13-AM/removeHomeExcludeList

INFO: OracleBaseDirList is: C:\DOCUME~1\tfeinzei\LOCALS~1\Temp\OraDeinstall2014-01-09_10-57-41\utl\orabase_cleanup.lst

INFO: Creating a new Inventory Session

INFO: Initializing the inventory session with access 1

INFO: Install area Control created with access level  1

INFO: Creating a new Install area Control for this inventory session with new  access level  1

SEVERE: oracle.sysman.oii.oiit.OiitTargetLockNotAvailableException: OUI-10020:The target area C:\Program Files\Oracle\Inventory is being used as a source by another session. A write lock cannot be obtained.
      at oracle.sysman.oii.oiit.OiitTargetLocker.handleActiveReader(OiitTargetLocker.java:757)
      at oracle.sysman.oii.oiit.OiitTargetLocker.updateReaderDatesTable(OiitTargetLocker.java:983)
      at oracle.sysman.oii.oiit.OiitTargetLocker.getWriterLock(OiitTargetLocker.java:341)
      at oracle.sysman.oii.oiit.OiitTargetLocker.getWriterLock(OiitTargetLocker.java:185)
      at oracle.sysman.oii.oiit.OiitTargetLocker.getWriterLock(OiitTargetLocker.java:172)
      at oracle.sysman.oii.oiic.OiicStandardInventorySession.acquireLocks(OiicStandardInventorySession.java:429)
      at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:311)
      at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:240)
      at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:189)
      at oracle.sysman.oii.oiic.OiicCleanup.cleanupOHLocal(OiicCleanup.java:1439)
      at oracle.sysman.oii.oiic.OiicCleanup.doOperation(OiicCleanup.java:893)
      at oracle.sysman.oii.oiic.OiicCleanup.main_helper(OiicCleanup.java:514)
      at oracle.sysman.oii.oiic.OiicCleanupWrapper.cleanOUI(OiicCleanupWrapper.java:187)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at oracle.install.db.deinstall.wrapper.clusterDeconfig.callCleanImpl(clusterDeconfig.java:1155)
      at oracle.install.db.deinstall.wrapper.clusterDeconfig.main(clusterDeconfig.java:462)

INFO: Oracle Universal Installer cleanup completed with errors.

INFO: Environment Variables:

INFO:       ORACLE_HOME =

INFO:       PATH = C:\DOCUME~1\tfeinzei\LOCALS~1\Temp\OraDeinstall2014-01-09_10-57-41\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem

INFO:       CLASSPATH = .;C:\Program Files\QuickTime\QTSystem\QTJava.zip

INFO: Username:tfeinzei

INFO: You can find a log of this session at:
'C:\Program Files\Oracle\Inventory\logs\\Cleanup2014-01-09_10-59-13-AM.log'

INFO: Ending the Inventory Session which was created
INFO: Ending the inventory Session
INFO: Disposing the install area control objects

Do not double click the BAT file.

Open a CMD prompt and manually set the ORACLE_HOME and manually run the deinstall.BAT script.

Hi Alex,

i placed this in the Run window

E:\app\tfeinzei\product\11.2.0\client_1\deinstall\deinstall.bat


When the Client installed, it does not seem to me to have created an Oracle_Home folder

It installed by default to the above location.

The pc already has an Oracle Folder  (so that i could communicated with the Oracle database using an old tool called Oracle Discoverer)

tx Alex!  sandra

Oh... sorry... Hi Slight

tx so much for writing...

ok...

will try it  and get back to you...

tx, sandra

Hi Slight,

i followed your suggestions

Pls see the above screenshot

It said that there are errors

Can you pls advise, tx, sandra

Hi Slight

yet it still show in programs/start
2014-01-09f-pgms.bmp

Hi Slight... yes i noticed that in oracle.com

http://docs.oracle.com/cd/B28359_01/install.111/b32007/deinstall.htm#i1008427

is removal with regedit    or   with window/control panel/remove pgms

can you pls advise, tx, sandra

Thx Slight and Alex!

Did you get the ODBC driver working?

Hi Slight,

i downloaded but did not install

i figured if i have any questions, i should open a related post

also at 1 pm have an hour webinar

will get back to you in an hour

thx!  sandra

>>i should open a related post

There really isn't a way to as a related question to this that would not be a duplicate of this one.

If you wish to continue working on this just post back and I'll unaccept it.

Hi Slight,

ok, i am back .... the webinar ended early...

i clicked on the basic zip file, i do not know what to do next

the read me file does not have clear instructions

can you pls advise.... so yes... i could use a bit more help....

can you re-open this post, please ....

thx, sandra

Hi Slight,

tx for reopening

so i created a folder call c:\Oracle_Basic_Install
     and pasted contents of both zip files in this folder as seen in the screen shot below


i looked around.... do not see a .bat file, and did a Windows search on ".bat"

Anyway, found some documentation, that says one must run the Instant before the ODBC as one of the files in the zip file

yet it does not explain clearly how to run the Instant

a
by any chance do you know, tx , sandra

Hi Slight,

this is what i tried so far:  thx

Hi Slight,

i think i have good news;
2014-01-09k-pgms.bmp

Hi Slight,

it now shows in Control Panel/Administrative Tools/ODBC in the Add dropdown a choice for Oracle

but

it's using the name of the folder that i created

===

oy... i spoke to soon, i got an error when i chose it:

Looks good to me.  Now just test it and makes sure that version works with your app.

Was typing.... will see what I can find on that error.

i tried this...

http://knowledgebase.progress.com/articles/Article/3052

i have to read it slowly.... will be back... thx

Hi Slight,

could it be that the instant client is not installed

could it be that i just ran the odbc_install

bec i do not know how to run the instant

will go huntlng in google about instant client

if the above is true, the documentation and i think you also said that instant has to be installed before driver

so do you recommend i go to control panel to DELETE THE ORACLE DRIVER .... pls advise... on deleting the driver

thx, sandra

maybe this:  also something about a PATH that it talks about below.... thx

http://www.oracle.com/technetwork/database/features/instant-client/index.html

Installation Steps:

1. Download the appropriate Instant Client packages for your platform. All installations REQUIRE the Basic or Basic Lite package.

2. Unzip the packages into a single directory such as "instantclient".

3. Set the library loading path in your environment to the directory in Step 2 ("instantclient"). On many UNIX platforms, LD_LIBRARY_PATH is the appropriate environment variable. On Windows, PATH should be used.

Hi Slight,

yes, downloaded regular Basic

am puzzled:  if there is not install for the Basic, how does Basic Client get installed

will read the link you provided

thx, sandra

Hi Slight,

i'm seeing the concept of PATH in a few places, even in the link provided

i was wondering if you are aware of this concept, and if yes could you explain

what PATH does, and where does one go to modify it, thx


from the link:


I added the c:\oracleodbc path to the %path%

wow, for the most part this link has the same issue as me!  thx... am still reading

Hi Slight,

ok, my brain is getting a little tired...

a) should i delete the driver from control panel to start fresh

b) i put the files from the 2 zipped filed into a folder called c:Oracle_Basic_Install but i do not see a folder with the name Instant created in the c:drive   (the 2 zipped files have the word Instant in the folder name)    so i do not know what to do with this recommendation in the link

i do not know what kind of screen shots to post......thx


As mentioned if you have unzipped basic.zip and odbc.zip in c:\oracleodbc it would put the dlls under a newly created directory called "instantclient10_2"
So you should have this directory in the path which has the dll's and not just the c:\oracleodbc

i think i see what i did wrong

i copied the files from the zipped folder  by doing a ctl+a, ctl+c in the instant folder

maybe i should have copied the sub folder in the zipped file to my new folder


thx

Hi Slight,

i looked closer at the subfolders and both contain the same folder, yet the duplicate folder name, one has the ODBC_install and the other one does not

Thx Alex for pointing out the redistributable package

and fthx Slight confirming Alex's idea

or vice versa Gentlemen, pls forgive me if i did not credit appropriately

i did not see the idea when first suggested.... will get back to you

Thx for this link:

http://www.teamqsi.com/question/how-do-i-add-a-oracle-odbc-data-source-for-a-teams-rds-database/


1.Extract both of the archives in to the same directory (ex. C:\drivers\Oracle\instantclient_12_1).   You may be prompted to merge the folders, click on Yes to continue.


i copied the instant folder from the basic zip to c:\Oracle_Basic_Install

then

i copied individual files from odbc folder to the instant folder, bec this zip file had a folder with the same name, and it prompted me to overlay the original instant folder

does that sound right, please?

thx, sandra

no problem, as long as we can help you solving this issue ;-)

Hi,

Now am up to Step 2

I am looking at the PATH variable under Control Panel

this is what it shows:   alot of stuff separated with ;

Am i supposed to modify it.... if yes, can you please guide me

Are there any screen shots of my folders that you would like to see in order to tell
me what to type

thank you:

PATH:

E:\app\tfeinzei\product\11.2.0\client_1\bin;C:\oracle\BIToolsHome_1\jdk\jre\bin\classic;C:\oracle\BIToolsHome_1\jdk\jre\bin;C:\oracle\BIToolsHome_1\bin;C:\oracle\BIToolsHome_1\jlib;C:\oracle\BIToolsHome_1\jre\1.4.2\bin\client;C:\oracle\BIToolsHome_1\jre\1.4.2\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\QuickTime\QTSystem\;C:\WINDOWS\system32\WindowsPowerShell\v1.0;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program Files\Common Files\Roxio Shared\10.0\DLLShared\

Hi Gentlemen,

i would love to follow your suggestion about the c++ variable

yet:

a) should i delete the "broken" oracle odbc driver in control panel so that i start fresh?

b) i am trying to follow the steps in this link

    and am stuck on step 2, what to type in for PATH variable

    Is it possible for you to look at what i pasted above to guide me as to if i should modify the PATH variable, or leave it as is.... thx


   i am so glad that i see PATH variable, yet i wonder what PATH means in general....

http://www.teamqsi.com/question/how-do-i-add-a-oracle-odbc-data-source-for-a-teams-rds-database/

Hi Alex,

a) thx... i think i generally understand it... thx!

PATH is like a nickname representing a longer path name

b) i hope this is ok:  i have a folder on this pc named Oracle with a folder named bin

i do not have a folder named Oracle_Home

c) i do not understand about putting the Path in a folder though
    i hope it's ok to follow the suggestion to put it in the PATH system environment variable

    if it's ok, how does the pc know since there is so much stuff separated by semi colons which segment is to be used by oracle as the nickname for its work

d) can you pls advise if i should delete the Oracle odbc entry that's not working to start fresh

really going for the day.... get home safe and sound everybody, sandra

Hi Gentlemen,

i downloaded 2010 redistributable first....

then ran the exe to do the install

pls see this screen shot... looks like there is a 2005 earlier version too

Anyway, i then when to control/panel...odbc   to add Oracle and got the 126 error again

Hi,

Just wanted to show a screen shot of where the Instant Client folder lives

wanted to recap:

i ran the basic zip file
when i ran the odbc zip file, it said duplicate folder bec both zip files contained instant folders of the same name

so i copied the files from the instant folder in the odbc zip file bec not too many files
using ctl+a   and pasted it into the instant folder

 

Hi,

It seems to me that the differerent YYYY links that you kindly supplied for redistributable, downloads a 2010 version

the x64 in the 2013 did not run
the x86 did, and installed the 2010 redist

However, the odbc still gives an 126 error

thx, sandra

Hi Slightwv,

yes, that's right... i read the diff bet x64 and x86   .... that's why x86 worked bec am

on windows xp

yes, my colleague does not work with Microsoft Access so he has not job need for ODBC

i work in a big organization, yet everyone knows what they do well....

iow, i will call the help desk yet am unsure if they will know what i need

tx gentlemen for everything, will get back to you, sandra

i ran the 2013 x86....

     i got the 126 error

     i removed it using control panel

then i ran the other versions

      then i notice in control panel that each YYYY version is installing 2010 redist

      so i started fresh and download the 2010

===

i just spoke to another colleague, it seems him and me are the only ones here who work with Microsoft Access and oracle

He said he just downloaded the full client:  win32_11gr2  and checked off the administrative option and it worked for him, so he is unable to help me

When he gave me the web page to download the win32_11gr2, i did not even get an entry in the ODBC,  which i got from the driver link that you provided

i will call the help desk now....
thx, sandra

I do not remember seeing the administrative option

will do what you suggested

and get back to you

i leave early on fridays.... will work on it on monday

thx soooooo much gentlemen,

Thx Gentlemen,

i want to close this post as completed.

the help desk told me that i am an administrator on this pc.

want to try to install the client.

i hope its ok that i am checking off all the answers .... i do not know which is the best answer so will choose the first one.

thx so much for your help, i learned alot from your help,

sandra

If we helped you answer the question then select the post or posts that helped.

If we did not help you answer it, just delete it.

You guys have been great....

yes, checked off the posts....

they were all helpful...

i am deeply grateful for both of your help....

thx so much, sandra

Hi Gentlemen,

Great News!

I tried again slowly..... and IT WORKS!!!!!!

I followed
   the additional steps in the link you provided, guessing my way through this:

http://www.teamqsi.com/question/how-do-i-add-a-oracle-odbc-data-source-for-a-teams-rds-database/

1)  i created a PATH variable  pointing to instant folder on my pc
2)  i created a TNS_ADMIN variable
      taking a chance and pointing it to the tnsnames.ora
     that is living in our BIintelligence folder that has the correct locations of our prod and test data stores (de-normalized tables for reporting)

3) i ran the odbc_uninstall.exe    in the command window after changing director
            for some reason the odbc_install.exe disappeared
                   so i went back to download the odbc folder and ran the
                               odbc_install
4) i then saw the odbc driver in  driver list window
          so i went to user dsn tabs, clicked add
                     and it brought up a window for me to name the odbc window
5) my colleague told me what to fill out . i set tables to read only

6) opened access 2010, get external data, odbc, link, machine data sources, pick odbc name, provide password

voila.... a holy moment.... pls see screen shot below

thank you soooo much gentlemen  ....
i could not have done it without you....



G-d bless you!!!!!

sandra

Glad we could help you, Sandra ;-)
For me, it's always great to have such a response & feedback (even for all the others searching for solutions like this one)...

Kind regards,
Alex