COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: garfunkal on 10 May 2012 03:15:49 AM

Title: DB2 ODBC connection successful but no tables returned!
Post by: garfunkal on 10 May 2012 03:15:49 AM
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? 

Title: Re: DB2 ODBC connection successful but no tables returned!
Post by: cognostechie on 10 May 2012 05:01:43 PM
The DB2 client needs to be installed on the machine and it has to be configured with the connection strings.
Title: Re: DB2 ODBC connection successful but no tables returned!
Post by: garfunkal on 10 May 2012 05:16:37 PM
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!
Title: Re: DB2 ODBC connection successful but no tables returned!
Post by: cognostechie on 10 May 2012 05:34:37 PM
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.