[ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Cannot connect to the instance.

[Tracy Li Gao]

I tried to install ServiceNow-ODBC-32-bit_1.0.15.exe, as windows server is 64bit, Microsoft excel is 32bit.

But got error when click "Test Connect": [SN][ODBC ServiceNow driver][ServiceNow Client]Failed to initialize the Service component.

I tried to resolve it according to the doc below, but it does not work.

ODBC Error Messages: Determining if your client application was unable to load the driver - Support ...

Then I tried to install ServiceNow-ODBC-64-bit_1.0.15.exe, But got error when click "Test Connect":

[SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Cannot
connect to the instance. (dataSource=2366386112856)
[user—odbc user]You are not authorized to perform this operation.
Please verify your credentials and try again.[1001]

Run command "connect odbc_user*password@servicenow;", get the output as attached.

Please help to provide your suggestions next.

[Tracy Li Gao]

The user odbc_user can login my PDI, and have given the role odbc.

[Tracy Li Gao]

Here is the odbc.log.txt for reference.

[Tracy Li Gao · Accepted solution]

I have installed ServiceNow-ODBC-32-bit_1.0.15.exe at first, then have it uninstalled as there is error could not be resolved, there is dirty data in ODBC Data Sources (32-bit) > tab System DNS > a line for Driver "ServiceNow ODBC Driver 32-bit"

I follow up below steps to remove the dirty data in ODBC Data Sources (32-bit), and reinstall ServiceNow-ODBC-64-bit_1.0.15.exe, and the issue resolved.

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"