Monday, 7 March 2016

Installing SQLPlus on Windows 10 and "MSVCP100.dll Missing"

Firstly to install SQLPlus on Windows 10 I downloaded two packages from Oracle.

The first "Instant Client Package - Basic Lite" has the main connection packages.

The second "Instant Client Package - SQL*Plus" has the SQLPlus elements.

Unzip these to a folder. I used "C:\Oracle\instantclient_12_1".

I then tried to run SQLPLUS.exe and got the error "The program can't start because MSVCR100.dll is missing from your computer. try reinstalling the program to fix this problem"

A quick Google search found that this is some kind of C++ library. I downloaded the necessary files from

I dropped my tnsnames.ora file into the instant client directory, ran SQLPlus again and voila.