Shulou(Shulou.com)06/01 Report--

This article introduces:

Install oracle instantclient odbc method under windows server 2008 r2(x64) environment

Background:

Because the server I built is a 64-bit system, but the application I use is 32-bit, I need to install 32-bit oracle odbc.

Follow the normal procedure:

1. Oracle official website (http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html) Download the following 32-bit package: (I choose the old version 11.2.0.4.0)

instantclient-basic-nt-11.2.0.4.0.zip

instantclient-odbc-nt-11.2.0.4.0.zip

instantclient-sqlplus-nt-11.2.0.4.0.zip

2. Extract all packages to d:\oracle directory;

3. Configure the environmental variables of the system:

path: add d:\oracle\;

New ORACLE_HOME: value d:\oracle\;

New TNS_ADMIN: value d:\oracle\network\admin\;

NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK or

AMERICAN_AMERICA.ZHS16GBK

4. Start-Run-cmd Enter d:\oracle directory and execute./ odbc_install.exe

can be seen

To uninstall odbc, execute odbc_install.exe under the same path;

5. Because it is a 64-bit system running 32-bit odbc, you need to use C:\Windows\SysWOW64\odbcad32.exe

You can see Oracle's driver.

6. Problem: Unable to load Oracle in instantclient_11_2 ODBC driver installation routine because of system error code 14001

Encounter the above problem, online check a lot of information are said environmental variables only, can not solve my problem.

He thought of various ways, but to no avail. Even if the operating system was reinstalled, it would be ineffective. (This is a clean system, nothing is installed. It's a clue, because I'm not wearing anything!!!

=========================================================================

fault analysis

=========================================================================

I thought it was an ODBC version problem, and downloaded version 12.1.0.2.0 from oracle official website to test

The environment variables are still set as standard oracle odbc, simply replacing files with other versions and installing odbc

The error still appears, but the error code has changed:

Unable to load the installation routine for Oracle in instantclient Driver because of system error code 126

I used Procmon.exe to track odbcad32's process pid and found that the program did not find 2 DLL files.

So add mfc100.dll and msvcr100.dll files (downloaded online) to the D:\oracle directory.

Odbccad 32 executes odbc again, the error is still the same, but the error code has changed again: error code 127

This time I used procmon to track the progress has been fruitless, no other related dependent files found.

The problem is deadlocked...

At last, use SxsTrace.exe, which is used to track the program, steps:

a. Restore oracle odbc to version 11.2.0.4.0 and install odbc (see installation steps above)

b. execute odbcad32 program, select oracle odbc driver, but do not click first.

c. Open cmd and run SxsTrace-logfile:d:\SxsTrace.etl (write log to d:\SxsTrace.etl).

d. Click odbcad32--oracle odbc driver--complete

e. Error 14001 occurred

f. Press Enter under cmd window to end tracing.

g、SxsTrace Parse -logfile:d:\SxsTrace.etl -outfile:d:\SxsTrace.txt

h. Open the generated log d:\SxsTrace.txt

I glanced at the logs, which were of little use, until the last sentence caught my attention when the word "error" appeared:

=========================================================================================

Error: Unable to resolve reference Microsoft.VC80.MFC,processorArchitecture="x86",publicKeyToken="1fc8b3b9a1e18e3b",type="win32",version="8.0.50727.762".

Error: Failed to generate activation context.

=========================================================================================

Do you have any thoughts about this?

My first thought was: no way... VC8.。。。。Microsoft.VC80。。。。。What does this mean? VC, right? D:\ORACLE directory also has VC8, VC9 directory, right?

I saw a glimmer of light... I made a big bend, it turned out to be VC problem...

So how?

I thought about it, it's nothing more than a running environment. Then I'll install a VC++ running environment.

A 32-bit vcredist_x86 on Microsoft's official website

Microsoft Visual C++ 2005 SP1 Redistributable Package (x86)

http://www.microsoft.com/zh-cn/download/confirmation.aspx? id=5638

Double-click install vcredist_x86, done

Open odbcad32 expectantly, select oracle odbc driver, and...

The familiar interface finally appeared…I really like big Pu Ben ~~~~~~~~~

i hope that my tortuous history of struggle with oracle odbc can give you some inspiration and reference.

Through the use of related tracking tools, troubleshooting and locking the cause of failure. I am glad to finally be able to solve this problem independently.

Windows server 2008 r2 x64 system installation oracle instantclient odbc 32-bit program, you need to install vcredist_x86 environment in the system

64-bit oracle odbc installation is no problem, the difference is that the use of system32\odbcad32.exe program to add odbc can be.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.