ODBC Error

[hima6]

Hi,

I'm try to get the data in Excel using ODBC. But I'm getting "Failed to initialize the Service Component" . How to resolve it. below is the screen shot.

Regards,

Hima Pallela.

[saritha9]

Check if all Data source properties are set correctly

[tony_barratt]

Hi Hima,

As mentioned by Saritha, it would be good to check if all data source properties are set correctly.

By running the following command from the ISQL commandline.

SELECT NUMBER, short_description FROM incident;

Using Interactive SQL With ODBC - ServiceNow Wiki

Can you let use know the results?

Best Regards

Tony

[hima6]

Hi Tony,

Earlier i installed ODBC 64bit & its working fine. Then to access ODBC through excel i uninstalled ODBC64 bit & Installed ODBC32bit. Now when i try to connect through iSQL, i'm getting error saying that "MSVCR71.dll" missing. i have downloaded this file & copied to C:\Windows\System32. But still getting same error.

Regards,

Hima Pallela

[hima6 · Accepted solution]

Thank you all for your reply. Now the issue got resolved. this "MSVCR71.dll" file has missed in my operating system & causing an issue. i have downloaded this file from web & included in my PC. Finally its working as expected.