How to install Oracle Instant CLient Basic + ODBC

- the basic instantclient does not comes with an installer (but i'm not sure about the ODBC package). you only need to extract it for eg to c:\Oracle_InstantClient

- next you need to add the following to the environment variables:
PATH=c:\Oracle_InstantClient;%PATH%
TNS_ADMIN=c:\Oracle_InstantClient
SQLPATH=c:\Oracle_InstantClient
LD_LIBRARY_PATH=c:\Oracle_InstantClient

- then copy the tnsnames.ora file from your database server into the client machine  c:\Oracle_InstantClient\TNS_ADMIN folder. you need to create the TNS_ADMIN folder

- then setup the ODBC using the Data Sources from the Administrative tool

Thanks, I will try that,  One more question we have Oracle 10g,  just to be sure I downloaded from

http://www.oracle.com/technetwork/topics/winx64soft-089540.html

the

Version 11.2.0.2.0

is this correct version Is should use or should I download

Version 10.2.0.5

Thanks a lot

- check you database version then check the instant client compatibility matrix below. basically the latest  instant client version support older database but some version requires fixes via oracle support (must have contract with oracle):

http://blog.whitehorses.nl/2010/02/19/database-version-compatibility-and-support-matrix/

I did your instructions and run the odbc_install there was no error, but I cannot fijnd the odbc drivers when I run odbcad32->Add

Any ideas?

- are you installing DSN for 32bit or 64bit application?
if 32bit run from c:\windows\syswow62\odbcad32.exe
if 64bit run from c:\windows\system32\odbcad32.exe

I did both I did not see the new ODBC driver, although I will be accessing the using 32 bit and I did

c:\windows\syswow64\odbcad32.exe

In our the XP client after the add I usually see

Oracle in OraDB10g_home1

but here what I saw is Microsoft ODBC for Oracle which says I need to install Oracle components

lets do some check:
- check that you download the right instant client version - check the compatibility matrix
- check that you add the variables in ID 35509681 above on SYSTEM (not user) environment variables
- both basic and odbc package is to be extract in the same directory then run the odbc_install

Thanks for the answer let me try the 64 bit one last time

With regards to environment variables, I had the SQLPath and LD_Library in user environment variables, I deleted and moved to System.  I am not sure how it got there as I press new in the System variables.

However it still did not work.

With regards to version I  downloaded the Windows 64 Version 11.2.0.2.0

I downloaded from this link

http://www.oracle.com/technetwork/topics/winx64soft-089540.html

All the files is in extracted in the following directory

C:\Oracle_InstantClient\instantclient_11_2

The  tnsnames.ora file is in

C:\Oracle_InstantClient\TNS_ADMIN

When I tried to run odbc_uninstall I got

Some problem occured while deleting the registry key.

When I tried running again the odbc_install I got

Oracle ODBC Driver with same name already exists.

If you do not see any problems I will try the 32 bit version although I am not sure how to fix the odbc_uninstall option

Thanks again

- create the tns_admin in C:\Oracle_InstantClient\instantclient_11_2 folder
- i would suggest you to read the Instant client release notes. look for your version:

http://www.oracle.com/technetwork/database/features/oci/odbc-ic-releasenotes-094306.html

Success!  The 32 bit version worked after the odbc_install

 However some corrections on variable path should be

TNS_ADMIN=C:\Oracle_InstantClient\instantclient_11_2\TNS_ADMIN

Its working perfectly Thank you very much