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

[tony_barratt]

Hi Kevin,

What output do you get when you run

SELECT NUMBER, short_description FROM incident;

on the isql commanline?

Using Interactive SQL With ODBC - ServiceNow Wiki

Running the isql command will indicate if the issue is between the ODBC driver and the instance or between the MS SQL server and the driver.

Best Regards

Tony

[tony_barratt]

Hi Kevin,

How are you getting on?

Best Regards

Tony

[krpurcel]

Tony,

When I use the ISQL interactive SQL I am unable to connect to the database.   I get an error saying "you are not connected to any database" (see attached screen shot).   However if I go into the ODBC Data Source Administrator, go to SYSTEM DSN and configure the ServiceNow ODBC Driver 32-bit, the test connection is successful. (See other attached screen shot).

My guess is I am not entering the command properly in the ISQL command window, but I am not sure.   Would you please look at my screen shots and make suggestions?

Thanks!

Kevin

[dhoffman]

Try it without the semicolon at the end.

CONNECT user*password@ServiceNow