Unable to connect to ServiceNow ODBC driver

[jmckay]

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 · Accepted solution]

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.

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

- Avneet

[jmckay]

Avneet,

Changing the heap settings did the trick!   I'm not sure what changed in my environment but changing the values to the suggested values allowed Crystal to connect to the ODBC driver.

Thanks very much!

-Jim

[harikrish_v]

HI James,

Once you have created the DSN and added the credentials for the instance, did you try the Test connection? Also in the ISQL console, can you try putting in this query and see if it is connecting:-

connect username*password@DSN_name;

If you have access to the customer service portal Hi, you can goto the links mentioned here and do the troubleshoot yourself:-

http://wiki.servicenow.com/index.php?title=Testing_the_ODBC_Driver#Troubleshooting

Thanks & Regards,

Hari

[jmckay]

Hi Hari,

Yes, the "Test Connect" button works.   The iSQL works and I can read the ServiceNow data using Excel.   It's only using Crystal Reports that I get the error message.   I'm going to try reducing the heap size as suggested by Avneet and see what happens.

Thanks,

-Jim