Unable to connect to ServiceNow ODBC driver

jmckay · ‎06-18-2014

Hi,

I have Crystal Reports 2011 and Windows 7 64 bit. I installed the 32 ODBC driver for ServiceNow and configured it according to the instructions in the wiki using the 32 bit ODBC administrator. When I try to connect to the data through Crystal I get an error message OpenAccess SDK Error: 10035 Failed to intialize the Service Component.

Does anyone have a clue what I need to do? I've uninstalled and reinstalled several times.

Thanks,

-Jim

akt_snow · ‎06-18-2014

Hi Jim,

You need to be logged into the Hi System.

Below are the steps mentioned in the resolution on the KB article:

Symptoms

driver not loading
driver times out waiting for a response

Cause

If you receive an error message during loading or initializing an ODBC driver connection, it is likely that the client application was unable to load the driver.

Resolution

If you receive the following error message when attempting to load or intialize the driver connection, [DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK Client]Failed to initialize the Service component., it may indicate that the client application (for example, Crystal Reports) was unable to load the driver. One of the reasons may be that the default Java maximum heap size is too large for the reporting application.

In the Management Console, navigate to Services > Service Settings > IP Parameters.
Reduce the value of ServiceJVMOptions to -Xms32m -Xmx64m.
If the error persists, reduce the memory more.

- Avneet

View solution in original post

solutioningnow · ‎06-18-2014

Hi,

As you have 64 Bit - Window 7, can you try installing ServiceNow ODBC 64 (https://shot.service-now.com/binaries/odbc/ServiceNow-ODBC-64-bit_1.0.7.1.exe)

Let me know if you have any queries.

Regards,

Solutioner

jmckay · ‎06-18-2014

Unfortunately, Crystal is a 32 bit app and I don't think that it can use a 64 bit ODBC data source.
Unless somehow I have to configure the 64 bit ODBC driver to get the 32 bit driver to work correctly.

-Jim

akt_snow · ‎06-18-2014

Hi James,

This usually happens due to the heap size.

The link below gives you the steps to reduce the JVM.

ServiceNow Customer Service System

Hope this helps.

- Avneet

jmckay · ‎06-18-2014

Avneet,

I can't get to the link that you posted in your message. Is there another way to get the information about reducing the heap size?

Thanks,

-Jim