cognos10.2.2 using ODBC to connect Oracle92 database (bmt-imp-0016)

For Cognos Server 64-bit Windows systems, note! Please download the 32-bit program. That

Because Cognos only recognized 32-bit ODBC programs. Be sure to pay attention here. For 64-bit Windows systems, ODBC has two programs, namely:

The 32-bit version of the Odbcad32.exe file is located in the%systemdrive%\windows\syswow64 folder.

The 64-bit version of the Odbcad32.exe file is located in the%systemdrive%\windows\system32 folder.

After we install, we want to open the ODBC program in%SYSTEMDRIVE%\WINDOWS\SYSWOW64 to configure. Never configure in ODBC in Computer Management in Control Panel because this is a 64-bit ODBC.

After the ODBC configuration such as (detailed parameters, very simple, here is not given, note that the DB encoding to be set in the detail. ）

The ODBC Configuration page for Cognos

bmt-md-6001 or bmt-imp-0016 error when running Metadata Wizard in Framework Manager Technote (troubleshooting) Problem (Abs tract)

When creating a new project using the Metadata Wizard, Modelers is presented with the following error message after Selec Ting a Data Source:
bmt-md-6001 Connection to the data source ' Great_outdoors_sales ' failed because a valid Connection string is not specifie D.
ODBC data source connections would return the following error:
bmt-imp-0016 the provider type OD is isn't supported in this mode.

Cause

The Framework Manager project is configured to use Dynamic Query Mode but no JDBC connection details has been entered in The Data Source connection in Cognos administration. For more details regarding configuring connectivity for Dynamic Query Mode, please refer to the "Data Sources and Connecti ONS "section of the Administration and Security guide.

Dynamic Query Mode does not support ODBC connections.

Resolving the problem

To resolve this issue, there is, and possible steps:

Switch to Classic Query Mode
1. If creating a new model, uncheck the "Use Dynamic Query Mode" option in the new Project window.
2. If updating an existing model, select the project item (the highest level item in the Project Viewer panel) and in the Pro Perties pane Set the Query Mode property to Compatible.

Configure JDBC Connection Details in Cognos administration

1. Using a Web browser, navigate to the Cognos Connection URL.
2. Log in as a user with administrative privileges.
3. Click Launch, Cognos administration.
4. Click the Configuration tab.
5. Click the name of the data source to be modeled.
6. In the Actions column, click the Set Properties icon next to the appropriate Data Source connection.
7. Click the Connection tab.
8. Click The pencil icon next to the Connection String entry.
9. Click the JDBC tab.
10. Ensure "Enable JDBC connection" is checked and fill with the details for the data source connection.
11. Click OK.
12. Open Framework Manager and run the Metadata Wizard.

Related information

Data Sources and Connections-administration and secur

cognos10.2.2 using ODBC to connect Oracle92 database (bmt-imp-0016)