Thursday, March 29, 2012

Fixing SqlDeveloper MSVCR71.DLL or MSVCR100.DLL not found error

Today I installed 64bit sqldeveloper on new Windows Server 2008 instance and oops ... I had strange error:

MSVCR100.DLL not found error - ok, I assumed it is JDK issue (i had only Java7 JDK installed which is not supported for SqlDeveloper 3.0.x).

After installing JDK6.x wasn't no changes.

Ok, I assumed the problem lies in non accessible MSVCR100.DLL. This dll is a part of Microsoft Visual C++ redistributable package, so I installed it. And again no changes.

I gave up and installed old 32bit version of sqldeveloper with bundled JDK. And surprise: error changes to MSVCR71.DLL not found.

After some googling I found the prompt. The problem lies in the erroneous registry entries. You sholud have entries visible like on image below:


The first (Default) string value is a path to sqldeveloper (with executable file), the second (Path) value is the path to JRE bin directory in used JDK.

Below reg file content you can use to fix similar problem:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\sqldeveloper.exe]
@="C:\\oracle\\sqldeveloper\\sqldeveloper.exe"
"Path"="C:\\oracle\\sqldeveloper\\jdk\\jre\\bin"

6 comments:

  1. Perfect -- Thank you!

    ReplyDelete
    Replies
    1. Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a Java developer learn from Java Training in Chennai. or learn thru Java EE Online Training from India . Nowadays Java has tons of job opportunities on various vertical industry.

      Delete
  2. I also had the same problem. I did not do the above as I did not see sqldeveloper.exe under Apppath in registry.
    But I fixed the problem differently.
    Simply run the batch file sqldeveloper under C:\Oracle\sqldeveloper\sqldeveloper\bin. It will automatically.
    The problem is with the running the sqldeveloper.exe file at C:\Oracle\sqldeveloper

    ReplyDelete
  3. Nice!! Many Many Thanks

    ReplyDelete
  4. Lovely SSS mine worked as you said...popping up eith error that I am running too new a Java to continue...so I am just gonna install a new Java...thanks

    ReplyDelete