<div>
Hi Alex, 
 
tx for writing 
 
win32_11gr2 &nbsp; &nbsp; 
windows xp &nbsp;32 
 
tx, s
</div>

<div>
tx Alex.. will try it.... will get back you tomm 
 
tx, sandra
</div>

<div>
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
</div>

<div>
<blockquote>
i downloaded driver now
</blockquote>
 
did you actually install it?!
</div>

<div>
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: 
 
<a href="http://docs.oracle.com/cd/B28359_01/install.111/b32007/deinstall.htm#i1008427" rel="ugc">http://docs.oracle.com/cd/B28359_01/install.111/b32007/deinstall.htm#i1008427</a> 
 
Can i just install the instant files &quot;on top&quot; of what my pc has now? 
 
pls advise, tx, sandra<a href="https://filedb.experts-exchange.com/incoming/2014/01_w02/827326/2014-01-09a-pgms.bmp" target="_blank" title="s1 (2.3 MB)"><img alt="s1" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/01_w02/800_827326/2014-01-09a-pgms.bmp" /></a>
</div>

2014-01-09a-pgms.bmp

2014-01-09c-pgms.bmp

2014-01-09b-pgms.bmp

ora-deinstall.jpg

<div>
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
</div>

<div>
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: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ORACLE_HOME = 
 
INFO: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;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: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CLASSPATH = .;C:\Program Files\QuickTime\QTSystem\QTJava.zip 
 
INFO: Username:tfeinzei 
 
INFO: Install area Control created with access level &nbsp;0 
 
INFO: Creating a new Install area Control for this inventory session with new &nbsp;access level &nbsp;0 
 
INFO: Install area Control created with access level &nbsp;0 
 
INFO: Creating a new Install area Control for this inventory session with new &nbsp;access level &nbsp;0 
 
INFO: Install area Control created with access level &nbsp;0 
 
INFO: Creating a new Install area Control for this inventory session with new &nbsp;access level &nbsp;0 
 
INFO: Install area Control created with access level &nbsp;0 
 
INFO: Creating a new Install area Control for this inventory session with new &nbsp;access level &nbsp;0 
 
INFO: Install area Control created with access level &nbsp;0 
 
INFO: Creating a new Install area Control for this inventory session with new &nbsp;access level &nbsp;0 
 
INFO: Install area Control created with access level &nbsp;0 
 
INFO: Creating a new Install area Control for this inventory session with new &nbsp;access level &nbsp;0 
 
INFO: Install area Control created with access level &nbsp;0 
 
INFO: Creating a new Install area Control for this inventory session with new &nbsp;access level &nbsp;0 
 
INFO: Install area Control created with access level &nbsp;0 
 
INFO: Creating a new Install area Control for this inventory session with new &nbsp;access level &nbsp;0 
 
INFO: Install area Control created with access level &nbsp;0 
 
INFO: Creating a new Install area Control for this inventory session with new &nbsp;access level &nbsp;0 
 
INFO: Install area Control created with access level &nbsp;0 
 
INFO: Creating a new Install area Control for this inventory session with new &nbsp;access level &nbsp;0 
 
INFO: Install area Control created with access level &nbsp;2 
 
INFO: Creating a new Install area Control for this inventory session with new &nbsp;access level &nbsp;2 
 
INFO: Install area Control created with access level &nbsp;2 
 
INFO: Creating a new Install area Control for this inventory session with new &nbsp;access level &nbsp;2 
 
INFO: Install area Control created with access level &nbsp;2 
 
INFO: Creating a new Install area Control for this inventory session with new &nbsp;access level &nbsp;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 &nbsp;1 
 
INFO: Creating a new Install area Control for this inventory session with new &nbsp;access level &nbsp;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. 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at oracle.sysman.oii.oiit.OiitTargetLocker.handleActiveReader(OiitTargetLocker.java:757) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at oracle.sysman.oii.oiit.OiitTargetLocker.updateReaderDatesTable(OiitTargetLocker.java:983) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at oracle.sysman.oii.oiit.OiitTargetLocker.getWriterLock(OiitTargetLocker.java:341) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at oracle.sysman.oii.oiit.OiitTargetLocker.getWriterLock(OiitTargetLocker.java:185) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at oracle.sysman.oii.oiit.OiitTargetLocker.getWriterLock(OiitTargetLocker.java:172) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at oracle.sysman.oii.oiic.OiicStandardInventorySession.acquireLocks(OiicStandardInventorySession.java:429) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:311) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:240) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:189) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at oracle.sysman.oii.oiic.OiicCleanup.cleanupOHLocal(OiicCleanup.java:1439) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at oracle.sysman.oii.oiic.OiicCleanup.doOperation(OiicCleanup.java:893) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at oracle.sysman.oii.oiic.OiicCleanup.main_helper(OiicCleanup.java:514) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at oracle.sysman.oii.oiic.OiicCleanupWrapper.cleanOUI(OiicCleanupWrapper.java:187) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at oracle.install.db.deinstall.wrapper.clusterDeconfig.callCleanImpl(clusterDeconfig.java:1155) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at oracle.install.db.deinstall.wrapper.clusterDeconfig.main(clusterDeconfig.java:462) 
 
INFO: Oracle Universal Installer cleanup completed with errors. 
 
INFO: Environment Variables: 
 
INFO: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ORACLE_HOME = 
 
INFO: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;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: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;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
</div>

<div>
Do not double click the BAT file. 
 
Open a CMD prompt and manually set the ORACLE_HOME and manually run the deinstall.BAT script.
</div>

<div>
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 &nbsp;(so that i could communicated with the Oracle database using an old tool called Oracle Discoverer) 
 
tx Alex! &nbsp;sandra
</div>

<div>
Oh... sorry... Hi Slight 
 
tx so much for writing... 
 
ok... 
 
will try it &nbsp;and get back to you... 
 
tx, sandra
</div>

<div>
<a href="https://filedb.experts-exchange.com/incoming/2014/01_w02/827354/2014-01-09e-pgms.bmp" target="_blank" title="s5 (2.3 MB)"><img alt="s5" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/01_w02/800_827354/2014-01-09e-pgms.bmp" /></a> 
 
Hi Slight, 
 
i followed your suggestions 
 
Pls see the above screenshot 
 
It said that there are errors 
 
Can you pls advise, tx, sandra
</div>

2014-01-09e-pgms.bmp

<div>
Hi Slight 
 
yet it still show in programs/start 
<a href="https://filedb.experts-exchange.com/incoming/2014/01_w02/827355/2014-01-09f-pgms.bmp" target="_blank" class="file-inline" title="s6 (2.3 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>2014-01-09f-pgms.bmp</a>
</div>

2014-01-09f-pgms.bmp

<div>
Hi Slight... yes i noticed that in oracle.com 
 
<a href="http://docs.oracle.com/cd/B28359_01/install.111/b32007/deinstall.htm#i1008427" rel="ugc">http://docs.oracle.com/cd/B28359_01/install.111/b32007/deinstall.htm#i1008427</a> 
 
is removal with regedit &nbsp; &nbsp;or &nbsp; with window/control panel/remove pgms 
 
can you pls advise, tx, sandra
</div>

<div>
Did you get the ODBC driver working?
</div>

<div>
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! &nbsp;sandra
</div>

<div>
&gt;&gt;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.
</div>

<div>
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
</div>

2014-01-09g-pgms.bmp

<div>
Hi Slight, 
 
tx for reopening 
 
so i created a folder call c:\Oracle_Basic_Install 
&nbsp; &nbsp; &nbsp;and pasted contents of both zip files in this folder as seen in the screen shot below 
 
<a href="https://filedb.experts-exchange.com/incoming/2014/01_w02/827395/2014-01-09h-pgms.bmp" target="_blank" title="s8 (2.3 MB)"><img alt="s8" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/01_w02/800_827395/2014-01-09h-pgms.bmp" /></a> 
i looked around.... do not see a .bat file, and did a Windows search on &quot;.bat&quot; 
 
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<a href="https://filedb.experts-exchange.com/incoming/2014/01_w02/827396/2014-01-09I-pgms.bmp" target="_blank" title="S9 (2.3 MB)"><img alt="S9" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/01_w02/800_827396/2014-01-09I-pgms.bmp" /></a> 
by any chance do you know, tx , sandra
</div>

2014-01-09h-pgms.bmp

2014-01-09I-pgms.bmp

<div>
Hi Slight, 
 
this is what i tried so far: &nbsp;thx 
 
<a href="https://filedb.experts-exchange.com/incoming/2014/01_w02/827407/2014-01-09j-pgms.bmp" target="_blank" title="s9 (2.3 MB)"><img alt="s9" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/01_w02/800_827407/2014-01-09j-pgms.bmp" /></a>
</div>

2014-01-09j-pgms.bmp

<div>
Hi Slight, 
 
i think i have good news; 
<a href="https://filedb.experts-exchange.com/incoming/2014/01_w02/827408/2014-01-09k-pgms.bmp" target="_blank" class="file-inline" title="s10 (2.3 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>2014-01-09k-pgms.bmp</a>
</div>

2014-01-09k-pgms.bmp

<div>
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: 
 
<a href="https://filedb.experts-exchange.com/incoming/2014/01_w02/827411/2014-01-09l-pgms.bmp" target="_blank" title="s12 (2.3 MB)"><img alt="s12" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/01_w02/800_827411/2014-01-09l-pgms.bmp" /></a>
</div>

2014-01-09l-pgms.bmp

<div>
Looks good to me. &nbsp;Now just test it and makes sure that version works with your app.
</div>

<div>
Was typing.... will see what I can find on that error.
</div>

<div>
i tried this... 
 
<a href="http://knowledgebase.progress.com/articles/Article/3052" rel="ugc">http://knowledgebase.progress.com/articles/Article/3052</a> 
 
i have to read it slowly.... will be back... thx
</div>

<div>
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
</div>

<div>
maybe this: &nbsp;also something about a PATH that it talks about below.... thx 
 
<a href="http://www.oracle.com/technetwork/database/features/instant-client/index.html" rel="ugc nofollow">http://www.oracle.com/technetwork/database/features/instant-client/index.html</a>
</div>

<div>
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 &quot;instantclient&quot;. 
 
3. Set the library loading path in your environment to the directory in Step 2 (&quot;instantclient&quot;). On many UNIX platforms, LD_LIBRARY_PATH is the appropriate environment variable. On Windows, PATH should be used. 

</div>

<div>
Hi Slight, 
 
yes, downloaded regular Basic 
 
am puzzled: &nbsp;if there is not install for the Basic, how does Basic Client get installed 
 
will read the link you provided 
 
thx, sandra
</div>

<div>
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% 

</div>

<div>
wow, for the most part this link has the same issue as me! &nbsp;thx... am still reading
</div>

<div>
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 &nbsp; (the 2 zipped files have the word Instant in the folder name) &nbsp; &nbsp;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 &quot;instantclient10_2&quot; 
So you should have this directory in the path which has the dll's and not just the c:\oracleodbc 
</div>

<div>
i think i see what i did wrong 
 
i copied the files from the zipped folder &nbsp;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
</div>

<div>
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 
 
<a href="https://filedb.experts-exchange.com/incoming/2014/01_w02/827424/2014-01-09m-pgms.bmp" target="_blank" title="s13 (2.3 MB)"><img alt="s13" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/01_w02/800_827424/2014-01-09m-pgms.bmp" /></a>
</div>

2014-01-09m-pgms.bmp

<div>
Thx Alex for pointing out the redistributable package 
 
and fthx Slight confirming Alex's idea
</div>

<div>
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
</div>

<div>
Thx for this link: 
 
<a href="http://www.teamqsi.com/question/how-do-i-add-a-oracle-odbc-data-source-for-a-teams-rds-database/" rel="ugc">http://www.teamqsi.com/question/how-do-i-add-a-oracle-odbc-data-source-for-a-teams-rds-database/</a> 
 
 
1.Extract both of the archives in to the same directory (ex. C:\drivers\Oracle\instantclient_12_1). &nbsp; 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
</div>

<div>
no problem, as long as we can help you solving this issue ;-)
</div>

<div>
Hi, 
 
Now am up to Step 2 
 
I am looking at the PATH variable under Control Panel 
 
this is what it shows: &nbsp; 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\
</div>

<div>
Hi Gentlemen, 
 
i would love to follow your suggestion about the c++ variable 
 
yet: 
 
a) should i delete the &quot;broken&quot; oracle odbc driver in control panel so that i start fresh? 
 
b) i am trying to follow the steps in this link 
 
&nbsp; &nbsp; and am stuck on step 2, what to type in for PATH variable 
 
&nbsp; &nbsp; 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 
 
 
&nbsp; &nbsp;i am so glad that i see PATH variable, yet i wonder what PATH means in general.... 
 
<a href="http://www.teamqsi.com/question/how-do-i-add-a-oracle-odbc-data-source-for-a-teams-rds-database/" rel="ugc">http://www.teamqsi.com/question/how-do-i-add-a-oracle-odbc-data-source-for-a-teams-rds-database/</a>
</div>

<div>
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: &nbsp;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 
&nbsp; &nbsp; i hope it's ok to follow the suggestion to put it in the PATH system environment variable 
 
&nbsp; &nbsp; 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
</div>

<div>
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 &nbsp; to add Oracle and got the 126 error again 
 
<a href="https://filedb.experts-exchange.com/incoming/2014/01_w02/827533/2014-01-09n-pgms.bmp" target="_blank" title="s13 (2.3 MB)"><img alt="s13" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/01_w02/800_827533/2014-01-09n-pgms.bmp" /></a>
</div>

2014-01-09n-pgms.bmp

<div>
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 &nbsp; and pasted it into the instant folder 
 
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2014/01_w02/827535/2014-01-09o-pgms.bmp" target="_blank" title="s14 (2.3 MB)"><img alt="s14" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/01_w02/800_827535/2014-01-09o-pgms.bmp" /></a><a href="https://filedb.experts-exchange.com/incoming/2014/01_w02/827536/2014-01-09p-pgms.bmp" target="_blank" title="s15 (2.3 MB)"><img alt="s15" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/01_w02/800_827536/2014-01-09p-pgms.bmp" /></a>
</div>

2014-01-09o-pgms.bmp

2014-01-09p-pgms.bmp

<div>
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
</div>

<div>
Hi Slightwv, 
 
yes, that's right... i read the diff bet x64 and x86 &nbsp; .... 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
</div>

<div>
i ran the 2013 x86.... 
 
&nbsp; &nbsp; &nbsp;i got the 126 error 
 
&nbsp; &nbsp; &nbsp;i removed it using control panel 
 
then i ran the other versions 
 
&nbsp; &nbsp; &nbsp; then i notice in control panel that each YYYY version is installing 2010 redist 
 
&nbsp; &nbsp; &nbsp; 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: &nbsp;win32_11gr2 &nbsp;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, &nbsp;which i got from the driver link that you provided 
 
i will call the help desk now.... 
thx, sandra
</div>

<div>
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,
</div>

<div>
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
</div>

<div>
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.
</div>

<div>
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
</div>

<div>
Hi Gentlemen, 
 
Great News! 
 
I tried again slowly..... and IT WORKS!!!!!! 
 
I followed 
&nbsp; &nbsp;the additional steps in the link you provided, guessing my way through this: 
 
<a href="http://www.teamqsi.com/question/how-do-i-add-a-oracle-odbc-data-source-for-a-teams-rds-database/" rel="ugc">http://www.teamqsi.com/question/how-do-i-add-a-oracle-odbc-data-source-for-a-teams-rds-database/</a> 
 
1) &nbsp;i created a PATH variable &nbsp;pointing to instant folder on my pc 
2) &nbsp;i created a TNS_ADMIN variable 
&nbsp; &nbsp; &nbsp; taking a chance and pointing it to the tnsnames.ora 
&nbsp; &nbsp; &nbsp;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 &nbsp; &nbsp;in the command window after changing director 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for some reason the odbc_install.exe disappeared 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;so i went back to download the odbc folder and ran the 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;odbc_install 
4) i then saw the odbc driver in &nbsp;driver list window 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; so i went to user dsn tabs, clicked add 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;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 &nbsp;.... 
i could not have done it without you.... 
 
<a href="https://filedb.experts-exchange.com/incoming/2014/01_w03/828008/2014-01-09q-pgms.bmp" target="_blank" title="s18 (2.3 MB)"><img alt="s18" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/01_w03/800_828008/2014-01-09q-pgms.bmp" /></a> 
 
G-d bless you!!!!! 
 
sandra
</div>

2014-01-09q-pgms.bmp

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

<div>
<div class="content wysiwyg-content">
Hi EE, 
 
I have Oracle beginner Knowledge... i am guessing my way... 
 
Please can you help.... 
 
I downloaded the Oracle client .... it installed successfully 
 
A colleague, gave me his tsnnames.ora file, so i copied it to: &nbsp; 
 
e:\app\myUsername\product\11.2.0\client_1\network\admin 
 
I go to Control Panel/Administrative/ODBC &nbsp; &nbsp;and 
 
&nbsp; &nbsp; &nbsp;I do not see Oracle ODBC in the dropdown list 
 
Any suggestion, please 
thx, sandra
</div>
</div>

Hi EE,

I have Oracle beginner Knowledge... i am guessing my way... 

Please can you help....

I downloaded the Oracle client .... it installed successfully

A colleague, gave me his tsnnames.ora file, so i copied it to:  

e:\app\myUsername\product\11.2.0\client_1\network\admin

I go to Control Panel/Administrative/ODBC    and

     I do not see Oracle ODBC in the dropdown list

Any suggestion, please
thx, sandra

How to install Oracle ODBC Driver  (for Microsoft Addess)

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.