Download oracleinstant-client specifically choose which version to see their actual needs, generally if the corresponding is 32-bit application then select 32-bit instantclient
- Download oracleinstant-client
Choose which version to see your actual needs, generally if the corresponding is 32-bit application then select 32-bit instantclient.
I chose the 11.2.0.3.0 version, there is a basic package, this package is a basic package, the basic components are in this package, of course, it can not be less, and then the ODBC package is the corresponding ODBC driver.
Note: The versions of the two packages must be consistent, otherwise the driver may not load ("IM003, system error 127" will report a similar error)
- Extract files, two files extracted content to be placed in the same directory
Look at the two pictures above, the top of the ODBC and the bottom of the basic content must be extracted into a path.
- Configuring the relevant environment variables for Oracle
Because this instantclient belongs to the green version of the thing, after decompression in order to use them, it must be to let the system understand them. The main environment variables are:
Oracle_home
Nls_language
Nls_admin
Concrete meaning, everyone to understand it, here is not much to say.
- Installing the ODBC driver
As shown, run its install ODBC driver, this EXE is a console application, too fast to see the results of execution, I have done this, edit a bat file, the content is:
In this way, the finished results can be seen in the 1.txt file.
- To see if the driver was successfully installed
Note in 64-bit systems, open this data source management tool through the control Panel to see the 64-bit driver management interface:
As can be seen, and without the driver we just installed, the 32-bit driver management program should be turned on by running the command:
C:\Windows\SysWOW64\odbcad32.exe
You can open the 32-bit driver management interface:
As you can see, there are a lot of 32-bit drivers, and we also see the 11.2 version of the driver that we just installed.
- Establishing an ODBC data source
OK, here the data source can be used by other applications.
Oracle Instant Client Installation configuration