ODBC connection issue

[krpurcel]

I'm trying to create an ODBC connection to ServiceNow per these two resources:

https://hi.service-now.com/kb_view.do?sysparm_article=KB0540707 — Allows you to download and install the 32 bit or 64 bit drivers for the ServiceNow ODBC connection and automatically created the System DNS.

http://wiki.servicenow.com/index.php?title=Using_ODBC_Driver_in_SQL_Server - shows how to set up your connection in SQL Server.

I installed the 32 bit ServiceNow driver.   Once that was done I was able to connect to my local database in SQL Server. When I try and follow the instructions to use the ODBC driver, I get to step 6. Select Security from the Select a page list, and enter the following security values. When I click OK at the end of step 6, I get the following error message. (See ServiceNow 32Bit error message attachment).

The error seems to indicate I am using the incorrect driver.   So after receiving it I uninstalled the 32 bit driver and installed the 64 bit driver. When installing the 64 bit driver, I get an error at step 6 that says "the server was not found or was not accessible". (See ServiceNow 64Bit error message attachment), and I am then unable to connect to my local database in SQL Server.

So I am unable to proceed past step 6 in the article.

Can anyone shed some light on what is happening and what I need to do to correct it?

Thanks!

Kevin

[krpurcel]

Tony & David,

My apologies, I have been on vacation for the last week and had not seen these replies.   I am back and am wading through email.   It will probably be tomorrow before I have a chance to review and try the suggestions.   Thanks very much for your replies.   I appreciate you taking the time to help me, and I will get back to you with my results.

Thanks,

Kevin