Issue
The ServiceNow ODBC driver may produce an error with "[DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK Client]Failed to initialize the Service component" message when the driver is installed on a Windows Server 2016, or Windows 10 host.
This issue may be experienced for both the 32-bit and 64-bit versions of ServiceNow ODBC driver.
Steps to reproduce:
- On Windows Server 2016 or Windows 10 host, download the driver per the following doc:
- https://docs.servicenow.com/csh?topicname=t_DownloadAndInstallTheODBCDriver.html&version=latest
2. Install the driver with default settings guided during the execution of setup application.
3. Go to the Microsoft ODBC Admin console to configure the DSN.
4. Set the Custom Properties to: url=https://<instance_name>.service-now.com
5. Click 'Apply'.
6. Click 'Test Connection'
You might get the following error message.
[SN][ODBC ServiceNow driver][ServiceNowClient]Failed to initialize the Service component.
Release
All ServiceNow ODBC Driver releases.
Resolution
This issue happens because some of the Microsoft Visual C++ 2010 libraries are not installed on (or bundled with) Windows Server 2016, or Windows 10 systems. In order to mitigate the issue, please install the package from the following link: