Because Snowball Was Taken

I recently installed Oracle SQLDeveloper on a clean install of Windows Server 2008. I had done this many times in the past with no problems, and so I was surprised when I went to run it and got this error:

This application failed to start because MSVCR71.dll was not found.This application failed to start because MSVCR71.dll was not found.

Wow. Been a while since I’ve seen that one.

Since this was a new install of Server 2008 I presumed the problem was simply that I didn’t have the Microsoft Visual C Runtime files. I went to Microsoft and and installed the recommended CRT files. No joy. Still not working.

I searched my computer for the runtimes to see where the install put them, and found nothing in the Windows folders, but several hits under the sqldeveloper folders. So, the runtime was included with the Oracle SQLDeveloper files, but because its folder was not on the path, there was no way for it be found. And the Microsoft runtime install, whatever it did, did not put the files where they could be found.

Hmm… How is this supposed to work? The SQLDeveloper app is simply a zip file. You don’t install it. Just unzip it. But if needs the CRT files, and these files aren’t in the Windows folder, how is this going to work? How did it ever work?

I also found this note on Microsoft’s knowledge base:

For Msvcr70.dll or for Msvcr71.dll, you should install the CRT DLL into your application program files directory. You should not install these files into the Windows system directories.

OK. So the runtime installer did the right thing. But, again, how would this work? Clearly Oracle is depending on the runtimes being available (i.e. improperly installed) in their software distribution strategy for SQLDeveloper. But, as Microsoft tightens the reigns, and as people start obeying the rules, this approach falls short. You can’t simply distribute it as a zip file and expect it to work. You’re going to have to provide a little bit of configuration to get the runtimes on the path.

The Solution

To fix it, properly, you need to install SQLDeveloper yourself. Fortunately, this is simple.

  • Run regedit as the Administrator
  • Expand HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths
  • Add a new Key to App Paths called sqldeveloper.exe
  • Set the (Default) value to the full path to the executable (including the executable name).
  • Create a new String value for sqldeveloper.exe called Path and set its value to the jre / bin folder in the SQLDeveloper files.

And here’s what it looks like:

Yes, I could provide you a script to make all these registry entries for you, but you really shouldn’t trust a script that makes changes to your system like that. And, you need to learn how to configure a Windows application anyway.

This problem isn’t limited to Oracle SQLDeveloper. It will be common to any application distributed without an installation process that is dependent on a runtime file that was formerly located in the Windows folder.

Follow up

I see where it’s being suggested that running the sqldeveloper.bat file in the bin directory also solves the problem. I haven’t tried this yet, and I don’t feel like experimenting at the moment. If this works, please let everyone know.

Comments

No Avatar
Visitor (not verified) on Tue, 17 May 2011 - 12:03am

it worked perfectly. Thanks!

No Avatar
Visitor (not verified) on Thu, 16 Jun 2011 - 5:03am

Ultimate post !!
Really this helped me a lot…….

Thanks !!

No Avatar
Visitor (not verified) on Thu, 14 Jul 2011 - 4:51am

Thanks a lot. I thought it’s useless like any other posts, but surprise! It works fine!!!

No Avatar
Visitor (not verified) on Thu, 1 Sep 2011 - 6:26pm

You rock mate!

No Avatar
Visitor (not verified) on Mon, 19 Sep 2011 - 8:10am

Excellent !!!!!
.Thank you

No Avatar
Visitor (not verified) on Tue, 27 Sep 2011 - 11:36am

Super nice. Thanks

No Avatar
Visitor (not verified) on Tue, 22 Nov 2011 - 7:07pm

Fixed the problem with Oracle SQL Developer, thanks!

No Avatar
Visitor (not verified) on Fri, 20 Jan 2012 - 6:28pm

This really worked. Thanks so much.

No Avatar
Visitor (not verified) on Sat, 28 Jan 2012 - 7:16am

big THANKS to you, buddy :)

No Avatar
Visitor (not verified) on Thu, 16 Feb 2012 - 2:56pm

Thank you for the detailed steps.

No Avatar
Visitor (not verified) on Sun, 26 Aug 2012 - 9:49pm

Thanks buddy!

No Avatar
Visitor (not verified) on Tue, 11 Sep 2012 - 4:33pm

+1 for sure!

No Avatar
Visitor (not verified) on Mon, 28 Jan 2013 - 1:36pm

thanks a lot

–Kishore

No Avatar
Ranma (not verified) on Tue, 1 Oct 2013 - 5:05am

Yes, it worked! Thanks a lot!

No Avatar
Balu (not verified) on Fri, 7 Mar 2014 - 1:40am

It Worked Thanks a lot

No Avatar
Visitor (not verified) on Mon, 21 May 2012 - 8:46am

Thanks a lot! You are the best!

No Avatar
Visitor (not verified) on Tue, 22 May 2012 - 5:03am

Perfect!! Thanks a lot..

No Avatar
Srinivas P V (not verified) on Thu, 19 Sep 2013 - 12:53am

Thanks a lot mate …it worked like a charm!!

No Avatar
Visitor (not verified) on Wed, 2 Oct 2013 - 2:42am

it worked perfectly. Thanks!

No Avatar
simon (not verified) on Thu, 24 Oct 2013 - 4:53pm

This post is still useful after 2+ years. It worked for me today.

Installing Oracle SQLDeveloper is like a throwback to stuff I did 15 years ago….shitty instructions, and random errors like this one that you helped with. I don’t miss those days.

No Avatar
Balraj (not verified) on Mon, 4 Nov 2013 - 2:56am

Thanks a lot for posting this, it worked perfectly for me

No Avatar
Java JDK (not verified) on Mon, 4 Nov 2013 - 9:31pm

Why, why do it through register? Just download Java JDK and set up the JAVA_HOME and PATH, it should work w/o any register update. You need Java JDK anyway if you are serious enough to do some kind of development by SQLdeveloper.

No Avatar
Visitor (not verified) on Tue, 12 Nov 2013 - 10:53am

STILL WORKS GREAT. THANKS!

No Avatar
Sneddy (not verified) on Tue, 4 Feb 2014 - 11:04am

Thanks a lot. It worked.

No Avatar
test (not verified) on Wed, 13 Nov 2013 - 11:17pm

Brilliant!!!!!! :-) it worked .. Thnx a lot :-)

No Avatar
Deepika (not verified) on Wed, 20 Nov 2013 - 1:33am

It Worked !!!!
Solution is simple & amazing.
Thanks a lot :) You are a genius….

No Avatar
Guilmor (not verified) on Thu, 21 Nov 2013 - 10:05am

Thank you very much!
It works indeed. Simple , but effective.

No Avatar
Steven (not verified) on Fri, 6 Dec 2013 - 9:45am

That’s it! :D Thanks!

No Avatar
Krupa (not verified) on Fri, 13 Dec 2013 - 3:29am

Thanks, your post really save me from lot of work

No Avatar
Deepak Arora (not verified) on Fri, 27 Dec 2013 - 3:37am

I am new to SQL developer and i faced this missing DLL and wrong location of jvm.dll. Then i had a look on JAVA_HOME, it was set for jdk7 but expected for jdk6, I installed jdk6 and retry to open sql developer. This time no more issue.

No Avatar
Swami (not verified) on Fri, 3 Jan 2014 - 4:52am

It worked. Thanks.

No Avatar
Karthikeyan R (not verified) on Fri, 3 Jan 2014 - 6:38am

This worked like a charm!! Thank you

No Avatar
Vinay (not verified) on Mon, 13 Jan 2014 - 7:19am

Worked Flawlessly ..!!! amazing.. before finding this i was planning to re-installing sqldeveloper..!!

No Avatar
Hardik (not verified) on Sun, 2 Feb 2014 - 5:46pm

It worked, I was moving my old sqldeveloper from my old laptop to new one and i didnt want to upgrade the Java , so I just moved the zip file , and got this error, followed your steps and it solved the problem.

Hurray…

Thanks

No Avatar
Visitor (not verified) on Fri, 21 Feb 2014 - 10:19am

Thanks a lot….It saved me lot of work……

No Avatar
Visitor (not verified) on Wed, 25 May 2011 - 9:34am

very clear instruction.
Thanks a lot for the solution.

No Avatar
Orlando (not verified) on Wed, 31 Jul 2013 - 9:16am

You saved my day, thank you very much :D

No Avatar
Visitor (not verified) on Tue, 21 Jun 2011 - 4:19am

Thank you !!! YOU are the man.

No Avatar
Visitor (not verified) on Tue, 19 Jun 2012 - 5:21am

Excellent solution

No Avatar
Visitor (not verified) on Wed, 20 Jun 2012 - 1:50am

Thanks :)… Worked for me too.

No Avatar
Visitor (not verified) on Thu, 21 Jun 2012 - 5:28am

God Bless you!
Worked great for me

No Avatar
Visitor (not verified) on Wed, 29 Jun 2011 - 11:15am

Perfect. Thanks.

No Avatar
Visitor (not verified) on Tue, 12 Jul 2011 - 8:34pm

It worked perfectly! Thanks a ton!

  • Pady

No Avatar
Visitor (not verified) on Wed, 13 Jul 2011 - 6:16pm

I was nearly despaired with this problem. But since I found this page I be happy because it’s a very good description how to fix it, and works perfectly. Many thanks!

The only thing I need to think was: “Run regedit as the Administrator”.
My solution: I locate C:\windows\regedit.exe via Explorer, use right mouse button and choose “Run as Administrator”.

No Avatar
Visitor (not verified) on Thu, 2 Aug 2012 - 7:20am

Thank you fot this one, saved me from trouble!

No Avatar
Visitor (not verified) on Thu, 14 Jul 2011 - 2:33pm

Aussum solution, Thanks

No Avatar
Visitor (not verified) on Fri, 29 Jul 2011 - 9:47am

Superb help, saved me trawling for a solution for hours. Much help!!!! :D

No Avatar
Visitor (not verified) on Tue, 16 Aug 2011 - 6:52pm

Perfect!! First Step 5, after, 1..4

No Avatar
Visitor (not verified) on Thu, 1 Sep 2011 - 9:16am

bravo, funge!

No Avatar
Visitor (not verified) on Fri, 16 Sep 2011 - 10:35am

You do rock. Thank you.

Pages