If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

DB2 ODBC connection successful but no tables returned!

Started by garfunkal, 10 May 2012 03:15:49 AM

Previous topic - Next topic

garfunkal

Hi

We are trying to connect to a DB2 database.  We can set up the connection which is successful, but when we come to use the data source in Framework Manager we can't see any tables - it completes but says ' no objects where imported'.

I think this is something I've not quite set up right in FM - If I try to connect using Access for example, we get all the tables fine, so I dont think its the id or the ODBC side.

Any ideas? 


cognostechie

The DB2 client needs to be installed on the machine and it has to be configured with the connection strings.

garfunkal

Hi. Db2 is installed, and registered for odbc with the correct schema. It's odd that it works in access but not cognos, and the connection seems successful.

When you say connection strings, you mean on cognos connection? How would the string syntax be set out? I read that a string wants required.

Should I be using odbc or composite?

Cheers for any help!

cognostechie

ODBC for sure. Composite is not required. I worked with DB2 before and I had the same problem. The data source tested fine from Cognos but FM was unable to see anything in the schema. I had to install the DB2 client and then open the DB2 client and in one of the screens there was an option to add connections. One of the ways to add connections was from the command prompt but you have to go to the command prompt from that option from within the client. Don't go there from the Run option of windows. Once I was there, I executed a connection string which I got from their DBA. That connection string adds the connection and then I could see that connection in the DB2 client screen. Then FM was able to see the tables.