Data Services Datastore Issue (BODI-1112346)

dataservices administration
1

I just had Data Services Installed on a new server for testing. I have datastores connections to a SQL database and a DB2 database. The SQL database connection works fine, but I am getting an error when I try to connect to any DB2 databases. I’ve created the ODBC connection for the DB2 databases and they test fine but I get the following error when I try to create the Datastore:

Error: Cannot load metadata table <name=all>
ODBC call for data source <‘name of databse’> failed
(BODI-1112346)

Has anyone seen this or know what is causing this error?

newBOuser (BOB member since 2009-02-12)

2

I had a similar issue that was eventually traced to the access protocol on the database. Data Services was trying to use named pipes but this protocol was disabled. Can you ask your DBA’s what protocols they have enabled?

Nemesis :australia: (BOB member since 2004-06-09)

3

My DBAs are morons and have no idea what this is, could you elaborate on what your DBAs did specifically so I can help them out?

newBOuser (BOB member since 2009-02-12)

4

Unfortunately, we had the problem on SQL Server and enabling the named pipes protocol is handled by the SQL Server management tools. We aren’t using DB2 so I’m afraid I can’t give the tool settings to change.

Nemesis :australia: (BOB member since 2004-06-09)