Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
ODBC Troubleshooting Checklist - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • ODBC Troubleshooting Checklist
KB0538995

ODBC Troubleshooting Checklist


15820 Views Last updated : Aug 24, 2022 public Copy Permalink English (Original)
  • English (Original)
  • Japanese
KB Summary by Now Assist

Issue

Before you begin following the steps in the ODBC troubleshooting path, review this checklist to make sure none of these items are present with your issue. If these issues do not apply to you, follow the troubleshooting path here.

Checklist

1. Is your operating system Windows 10?

The ServiceNow ODBC driver is compatible only with the Windows operating system and does not work with any other operating system such as Linux, UNIX, or macOS. Windows 10 is supported starting with the ODBC driver version 1.0.13.

2. Is your operating system Windows 2012?

Windows 2012 is supported starting with the ODBC driver version 1.0.9.

3. Does the user who will be connecting to the ServiceNow database have a SOAP role or the ODBC role assigned?

If the instance has glide.soap.strict_security=true, the user must have an appropriate SOAP role, or the ODBC role starting with Helsinki. For the list of roles, see Base System Roles in the product documentation.

4. Does the user who will be querying a particular table have privileges to access it?

Check the table’s ACL. For more information, see Using Access Control Rules in the product documentation.

5. Does your user name and/or password contain special characters?

In this case, customconnect should be used instead of connect:

customconnect "DSN=<System DSN>;UID=<username>;PWD=<password>"

6. Do you access the instance via proxy?

If yes, configure the ODBC proxy settings using these instructions from the product documentation: Configure ODBC to use proxy servers.

7. Are you trying to configure Microsoft SQL Server Integration Services (SSIS) to work with ODBC?

Make sure that you are using the 32-bit version of the ODBC driver regardless of the OS bitness.

8. Are you using an Active Directory (AD) account to connect to the instance with the ODBC driver?

When using the ODBC driver, connect with a user record defined on the instance instead of an Active Directory account.

9. Do users connect to the instance using Single Sign-on?

When using the ODBC driver, connect with a user record defined on the instance instead of an SSO account.


The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.