Error while Configuring ODBC Driver

[disharajvanshi]

Hi Community,

After providing username and password in ODBC DSN, we are getting error which says " [OpenAccess SDK SQL Engine]Cannot connect to the instance. [dataSource = 2693263508632] [user=odbc_test] java.lang.NoClassDefFoundError:org/bouncycastle/jcajce/provider/BouncyCastleFipsProvider[1001]

Please help with the solution.

Thanks

Disha

[Saloni Suthar]

Have you looked at https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1580666 ?

[emoffett]

Hello, I had the same issue, and I recently was able to solve it. I found after more careful reading of the installation instructions there are steps after installing the odbc driver application which includes installing the dependencies like the jar for the BouncyCastleFipsProvider.

Per Download and install the ODBC driver:

12. Download the ODBC Driver Dependencies (2.0.0) file from ServiceNow Store after the installation is successful.

Then, extract the JARs (bcpkix-fips-1.0.3.jar, bc-fips-1.0.2.4.jar) to a local folder on your Windows machine. For example, <Windows-machine-local-path>\<folder-name>.

13. Navigate to All > ServiceNow ODBC > Management Console > ServiceNow ODBC Manager > Manager (local configuration) > <drive>:\Program Files\ServiceNow\ODBC\cfg\adm.in > Services > ServiceNow_ODBC > Service Settings > IP Parameters.

14. Open the ServiceJVMClassPath parameter.

15. Append the value with the location where the bc-fips-1.0.2.4.jar and bcpkix-fips-1.0.3.jar JARs are extracted.

For example, the location of jars will be in this format: <Windows-machine-local-path>\<folder-name>\bc-fips-1.0.2.4.jar;<Windows-machine-local-path>\<folder-name>\bcpkix-fips-1.0.3.jar

---

After following these steps, the error was resolved for me! I hope it helps you.