ODBC Call for Data Source Failed (Web Service)

dataservices job design
1

Hello,

I’m trying to connect to the ServiceNow DataBase with BODI

FYI : The ServiceNow ODBC Driver allows any ODBC client to connect to the ServiceNow platform for reporting. ServiceNow ODBC driver uses the ServiceNow Web Services support. http://wiki.service-now.com

So I created a system DSN ServiceNow on my workstation and on the JobServer. I can access the database using this DSN on my workstation and on the JobSerer using Access, ISQL,…
But I can’t create a Datastore using this DSN to access the ServiceNow database and I receive this error :

WARNING :Cannot establish database connection.
ODBC call for data source failed: <[DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK Client] failed to create the Core Service component.>.Notify Customer Support.’(BODI-1111341)

Is it possible to create a DataStore using a DSN on the ODBC ServiceNow?
Does anyone has ever had this problem?

Thank you in advance.

Francesco.

F_Romeo :belgium: (BOB member since 2011-01-12)

2

Hi,

I just came across your message. I am running Data Services 4 SP2. I tried to do the same and when I try to add a data store pointing to the ServiceNow odbc driver my designer crashes !

Let me know if you resolved this and if you did which version of the odbc driver you have - I have the latest one.

Leigh Kennedy :australia: (BOB member since 2012-01-17)

3

Hi All,

I have similar issue. Can someone pls suggest me. This I face when i try to see the data from a temporary/permanent table thru BODS.

ODBC call for data source failed: <[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘abcadm’.>. Notify Customer Support.

Thanks in Advance…

klkreddy83 :uk: (BOB member since 2011-03-07)

4

The Designer cannot use the datastore properties to login to your SQL Server database. Your jobserver seems to be able to execute the job however. And how you imported the table structure into designer when there is a login failure, strikes me.

Werner Daehn :de: (BOB member since 2004-12-17)

5

Hi Werner,

I have the server re-started, the SQL connections are restored. The Table structure was already there, i mean this happened with the existing job in the designer.

Thank You!!

klkreddy83 :uk: (BOB member since 2011-03-07)

6

I hate these kinds of error. You never know what the root cause was and hence it might happen at any time again, usually in the worst possible moment.
Who does still believe computers work deterministic? :mrgreen:

Werner Daehn :de: (BOB member since 2004-12-17)

7

Hi Werner,

After re-starting the server, I dont see the issue :nopity:

Thanks,

Lakshmikar

klkreddy83 :uk: (BOB member since 2011-03-07)

8

Leigh, do you have any update to your issue ? Got anywhere with it? Really digging into an old one…I know :roll_eyes:

ganeshxp :us: (BOB member since 2008-07-17)