ODBC Test Connection getting failed

[sk59]

Hi All,

I have followed steps from ServiceNow youtube and wiki page of how to set ODBC connection to SNow instance. My account is already in admin roles and soap roles in dev instance which mean I have access pretty much everything. I already set up IP Properties in Manager Console using correct url link to my dev instance(https://******.service-now.com). Then in System DSN on Test Connect, I enter userid and password and here the error I got,

 

Please suggest what this error refers to and how to get rid of this?

[Paul35 · Accepted solution]

Hi, 

Assuming you are using the latest ODBC driver: 1.0.14

The error arises when the following file is missing from your windows system32 (or syswow64) folder [MSVCR100.dll] which is required for the ODBC driver. 

To obtain the missing dll, you can either:

- Download Java 

- Download the Microsoft Visual C++ redistributable 2010 (I've had varied success with this and prefer the java install)

Steps to obtain from Java are as follows:

1) Download Java (JRE 1.8.0_181 at time of writing).
https://www.java.com/en/download/manual.jsp
If you are using the x64 bit driver, then download: Windows Offline 64bit
If using x86 driver, download: Windows offline

2) Install Java.
3) Go to: C:\Program Files\java\jre1.8.0_181\bin\ (NOTE: it will be Program Files (x86)\ for 32bit install).
4) Copy msvcr100.dll
5) Go to: C:\Windows\system32\ (NOTE: c:\Windows\syswow64\ for 32bit).
6) Paste msvcr100.dll in this directory

7) Open ServiceNow ODBC manager, Go to: ServiceNow_ODBC > Service Settings > IP Parameters

😎 Update "ServiceJVMLocation" with the directory of your Java install that contains jvm.dll (ie. C:\Program Files\Java\jre1.8.0_181\bin\server)

9) Save configuration then test

Hope that helps,

Paul

[fchuck]

Paul - 

Thanks for the tips. I followed your steps but i am still getting the same error - Failed to Intialize the Service Component. For the System DSN setting, Service Data Source, is that just set to ServiceNow ?

Thanks

Ian

[Paul35]

Hi fchuck,

The "Service Data Source" should be set to whatever data source you set up within the "ServiceNow ODBC Manager".

If you are still receiving the error, I would check the following:

- The version of Java corresponds with the version of ODBC driver install. ie. 64bit driver should have Java 64bit installed

- Confirm the "ServiceJVMLocation" points to the correct Java folder.

- See if "msvcr100.dll" exists in the windows system folder

Failing those, you can raise an incident in HI for one of our engineers to work with you on the issue.

Hope that helps,