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
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
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
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
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