Connecting to an AS400 box

[Bluebird]

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

[mikegreen]

Can you setup the ODBC Connection in your ODBC Administration and then call it using ODBC from CRN? 

Regards,

Mike

[turnonthejets]

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