COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: Bluebird on 13 Dec 2005 11:24:36 AM

Title: Connecting to an AS400 box
Post by: Bluebird on 13 Dec 2005 11:24:36 AM
Can anybody advise which database connection type I should use in order to set up our AS400 box as the data source for my new Framework Manager project?Ã,  The one I was looking for - iSeries Access ODBC driver - is not in the list.Ã,  Thanks.

BB
Title: Re: Connecting to an AS400 box
Post by: mikegreen on 14 Dec 2005 12:03:56 PM
Can you setup the ODBC Connection in your ODBC Administration and then call it using ODBC from CRN? 

Regards,

Mike
Title: Re: Connecting to an AS400 box
Post by: turnonthejets on 14 Dec 2005 12:31:31 PM
It sounds like you're looking for an ODBC connection.  If this is correct then follow Mike's advice.  If not you can connect directly using DB2 Connect as noted at the software environments page on Cognos' website.

http://support.cognos.com/en/support/products/crn11mr2_software_environments.html#ds

DB2/400 V5R1 via DB2 Connect 8.1  Compatible
DB2/400 V5R2 via DB2 Connect 8.1  Active