MSVCR100.DLL error launching SQL Developer 4.1.2 with JDK 8 on Windows 7

Environment: Windows 7 Enterprise SP1 64-bit, SQL Developer with JDK 8 included.

Me again :-)

I recently faced an issue installing SQL Developer 4.1.2 on Windows 7, and it took me some time to find the solution, so I’m going to share it…

I downloaded version 4.1.2 of SQL Developer from, I selected “Windows 64-bit with JDK 8 included” from the list.

I rarely have problems running or upgrading SQL Developer on Windows, but this time was a different experience. After extraction of the zip file to a new folder, I double-clicked “sqldeveloper.exe”, and (surprisingly!) the following error message appeared:

The program can’t start because MSVCR100.dll is missing from your computer. Try reinstalling the program to fix this problem.


Followed by:

Unable to launch the Java Virtual Machine located at path: …


I was confused. The file MSVCR100.dll is part of the included Java Development Kit, so why wasn’t SQL Developer able to find it? I never had an issue like this with previous versions of SQL Developer (I always choose the version with included JDK to avoid Java issues like this one).

After some searches on Google, I found that someone suggested to copy the file MSVCR100.dll from the folder ..\jdk\jre\bin to ..\sqldeveloper\bin, so in my case from C:\sqldeveloper41\jdk\jre\bin to C:\sqldeveloper41\sqldeveloper\bin. Guess what? This worked! SQL Developer started, I could import my previous configuration and everything is looking good :-)



APEX 4.2.1 and APEX Listener 2.0 released!

First of all: a happy New Year to all my blog readers! I wish you an exciting 2013 with lots of interesting projects, no budget restraints and no unexpected downtime ;-)

When I returned from the Christmas holidays, I noticed that both Application Express 4.2.1 and the APEX Listener 2.0 have been released!

APEX 4.2.1 is actually the first patch set release for APEX 4.2. You can download the full release here (for new installations or upgrades) or, if you have a support contract, you can download the patch only (with number 14732511) here (for upgrades from version 4.2). There are a lot of bugs that have been fixed with this patch set (check for a full list here),  and also some new features have been introduced, for example the inclusion of AnyChart version 6 (which has even more HTML5 support). I’m happy with this patch set release, since this means it’s time to upgrade for us. We had some issues in the past after upgrading to a minor APEX release, so I learned to have patience and wait for the first patch set ;-)

Application Express Listener 2.0 was available as a Early Adaptor version for a while, but now the first production release is available. There are a lot of new features, like the ability to define multiple database connections, and more support for RESTful services. There are now also 2 ways to configure it: using SQL Developer (you need at least version 3.2.2) and using a new command-line interface. The web interface however has been removed, which I find a bit sad because I liked it :( We are using the APEX listener deployed to GlassFish, and I’m not sure if anything has changed in that matter. This is something I need to look into. I also wonder how you would upgrade from a previous version of the APEX Listener to this one. I suppose this involves some redeployment, and so also some (planned) downtime.



Installation of Oracle SQL Developer 3.2 64-bit on Windows 7 64-bit

Environment: Oracle SQL Developer 3.2.09 64-bit, Java 1.6.0_34 64-bit, Windows 7 64-bit

Oracle recently released version 3.2 of SQL Developer. This new version has some interesting new features, like the possibility to administer the APEX Listener, the option to connect to databases in the cloud, and an improved DB Diff wizard. To read more about the new features, check this page.

There are both 32-bit and 64-bit versions of the software. I will explain here how you can install the 64-bit version on Windows 7 64-bit.

1) Download and install 64-bit Java 6 JDK

The 64-bit version of SQL Developer does not include a Java Development Kit, but you need a Java 6 JDK to run it. If you don’t already have one on your system, you can download one here: I downloaded and installed jdk-6u34-windows-x64.exe, the 64-bit version of Java 6 Update 34 for Windows 64-bit.

2) Download and install 64-bit SQL Developer

If you have any previous versions of SQL Developer installed, do not remove them! You should only remove them after the new installation has finished successfully.

SQL Developer can be downloaded here: You need the “Windows 64-bit” version.

After the download, extract the “” ZIP file to a temporary folder and then copy/move the folder “sqldeveloper64-” to C:\Program Files. This is where Windows 7 by default installs its 64-bit programs and I prefer to keep it that way.

Now start SQL Developer for the first time by right-clicking on “sqldeveloper.exe” inside the “sqldeveloper” folder. It will now ask for the path to your 64-bit java.exe. Browse to C:\Program Files\Java\jdk1.6.0_34\bin\java.exe. This is the Java 6 JDK that you installed in step 1.

If you have any previous installations of SQL Developer installed, the new version should now show them and you will be given the possibility to import an old configuration. Might be handy to keep your connections and stuff!

SQL Developer should now start up fine. You can check the version under Help -> About.

When you have verified that everything works fine, you are safe to remove any older versions that you should have.


Have fun,





Changing the language of Oracle error messages in SQL Developer

Environment: SQL Developer 3.1.07, Windows 7

The regional format of my Windows 7 PC is set to “Dutch (Belgium)”. This means that some programs will display error or other messages in Dutch, which can be a problem when you need to look up information on the internet.

For example, I had the following Dutch error message in SQL Developer:

Error report:
ORA-06502: PL/SQL: numerieke fout of fout in waarde .
ORA-06512: in “SYS.OWA_UTIL”, regel 356
ORA-06512: in “APEX_040100.HTMLDB_UTIL”, regel 449
ORA-06512: in regel 2

To change this into another language, you need to modify the NLS “Language” setting in SQL Developer. You can do this from the “Tools” menu, then “Preferences”, “Database” and “NLS”. Change the language in the first drop down list (“Language”). Once you click “OK”, the changes take immediate effect. You don’t need to restart SQL Developer.

After the language change, this is how my error message now looks like:

Error report:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at “SYS.OWA_UTIL”, line 356
ORA-06512: at “APEX_040100.HTMLDB_UTIL”, line 449
ORA-06512: at line 2