cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Java based administration utilities such as DBISQL require msvcr100.dll?

5,086

We have installed the minimal set of files in the Bin32 folder under Windows based on the documentation. We are not using encrypted connections or FIPS-certified AES in the database. We are just using regular AES database encryption and are installing the required dbrsa17.dll as documented. When test installing on a totally clean Windows build (i.e. one without msvcr100.dll located anywhere on the system), all the Java based administration utilities fail to launch, complaining that this file is missing and then saying:

Could not load the Java virtual machine library ...Bin32\\jre180\\bin\\server\\jvm.dll Windows error code 126 The specified module could not be found.

Adding msvcr100.dll to the Bin32 folder solves the problem. However, the documentation talks about different files for x86 (mscvr90.dll) and x64 (msvcr100.dll). SQLA17 does not install mscvr90.dll anywhere that I can find and seems to install msvcr100.dll under x86 also. Is this correct and are the other files for encrypted connections or FIPS-certified AES encryption required even though we are not using this?

Accepted Solutions (1)

Accepted Solutions (1)

jack_schueler
Product and Topic Expert
Product and Topic Expert

Both 32-bit and 64-bit administration tools like Interactive SQL and SQL Central (the Java-based tools) now require msvcr100.dll, as now documented here.

VolkerBarth
Contributor
0 Kudos

Jack, the 17.0.4.2100 Deployment Wizard's master.xml file (in the "Deployment" subdir) still mentions the msvcr90.dll, possibly related to the 32-bit FIPS add-on. So is there still a need to include that one here?

(I'm just asking out of curiosity, I have not installed the FIPS add-on myself...)

jack_schueler
Product and Topic Expert
Product and Topic Expert
0 Kudos

The "90" DLL is required by OPENSSL components, ssleay32.dll and libeay32.dll.

If you have Visual Studio, try this...

dumpbin /dependents bin32\\ssleay32.dll

VolkerBarth
Contributor
0 Kudos

Thanks for the pointer!

I do not have the OpenSSL components (neither 32-bit nor 64-bit, neither on 12.0.1, 16.0 nor 17.0.4 - should they be installed?) but the following listed "msvcr100.dll" as expected (among other libs):

dumpbin /dependents "%SQLANY17%\\bin64\\jre180\\bin\\server\\jvm.dll"

jack_schueler
Product and Topic Expert
Product and Topic Expert
0 Kudos

The "eay" DLLs are part of the FIPS-certified encryption, documented here: http://dcx.sap.com/index.html#sqla170/en/html/815b96696ce21014bedce01d554ac4b4.htm

Do you have dbfips17.dll and the license to use the FIPS-certified encryption technology?

VolkerBarth
Contributor
0 Kudos

No, so that explains the missing DLLs (or why I do not really miss them:)...).

jack_schueler
Product and Topic Expert
Product and Topic Expert

Re: I do not have the OpenSSL components

I should also have clarified that you do have OpenSSL code (dbrsa*.dll), just not the FIPS-certified components.

Answers (0)