Import Notes Sql(.nsf file) into Cognos FM 8.4.1 using ODBC datasource

[saumil287]

Hi all,
I need to import NotesSql database into FM, I created a datasource for NotesSql files(.nsf file) which connected sucessfully but when I select the datasource and click on next gives the foll error.

QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
Domino

UDA-SQL-0031 Unable to access the "Domino" database.
UDA-SQL-0449 An error occurred when allocating memory during the "attach" operation.
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

The foll link shows to connect to .nsf file
http://www.builderau.com.au/architect/database/soa/Create-an-ODBC-connection-to-a-Lotus-Notes-database/0,339024547,320282240,00.htm

Thanks

[saumil287]

Hi All,
I restarted the machine and it worked properly,
But when I select the table and click on import,
It is returning the following error

RQP-DEF-0177 An error occurred while performing operation 'sqlOpen' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "AOpen".
[Lotus][ODBC Lotus Notes]Function sequence error

thanks in advance

[saumil287]

Hi All,
When I import tables from view,It is importing sucessfully under the namespace as query subject,but on right clicking and selecting on test gives the following error as follows:
This query contains an error and can not be executed.

It is recommended that you view the query feedback on the "Query Information" tab.

RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactive.
UDA-SQL-0107 A general exception has occurred during the operation "declare(error code: -27)".
[Lotus][ODBC Lotus Notes]Driver not capable

[tupac_rd]

Change the SQL settings from Cognos to Native, and change the sql statement to

select * from table name

instead of

select * from [datasource].table name

[saumil287]

Hi
I am able to test the data from some of the imported query subjects.
Some query subjects contain multiple columns with same name and some data types are not supported.

When I click on options in the test Dailog,It only shows Test Settings but not Sql settings.

I want to know one more thing whether it is possible to import(test) data from a table which contains multiple columns with the same name.

2nd thing, Can we test the data from a table which is a combination of 2 or more table.

Thanks in advance