- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-30-2022 02:27 AM
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.
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2022 02:15 AM
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"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-30-2022 02:28 AM
The user odbc_user can login my PDI, and have given the role odbc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-30-2022 02:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2022 02:15 AM
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"