If you are connecting to an ODBC data source that has been set up as a user DSN, ensure that the service using the connection is running as the user who created the data source. System DSNs are not restricted to the user who created the data source.

Note: In order to create and test reports with user DSN data sources, you must set up the Cognos8 service with a user account. User DSN data sources are invisible under a system account.

When you create connections to ODBC data sources, select the vendor-specific data source type, such as Microsoft SQL Server (ODBC), from the Type menu in the New Connection wizard.

Select ODBC to connect to an ODBC data source type that does not appear in the menu.