acess ServiceNow data using SQL API

[Vedavalli]

Hi,

Anyone faced this issue while 

Install ServiceNow SQL API ODBC driver on client machine.
I followed the below document:https://www.servicenow.com/docs/r/zurich/api-reference/web-services/install-odbc-driver.html


How to solve this issue?

[Tanushree Maiti]

Hi @Vedavalli 

Follow the steps as suggested by this community post : [ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Cannot connect to the instance. 

1.  1. Uninstall ServiceNow-ODBC-64-bit_1.0.15.exe
   2. Install ServiceNow-ODBC-32-bit_1.0.15.exe
   3. Go to ODBC Data Sources (32-bit), tab System DNS > remove the line for Driver "ServiceNow ODBC Driver 32-bit"
   4. Uninstall ServiceNow-ODBC-32-bit_1.0.15.exe
   5. Install ServiceNow-ODBC-64-bit_1.0.15.exe
   6. Go to ODBC Data Sources (64-bit), tab System DNS > click and configure the line for Driver "ServiceNow ODBC Driver 64-bit"

Also refer: 

KB0621675 Recommended procedure to Re-Install/Upgrade the SN odbc driver 

KB0538943 Troubleshooting ODBC driver issues 

KB0695352 The ODBC driver might fail to connect when installed on a Windows Server 2016, or Windows ... 

ODBC Driver Issues