Hi,
I am trying to connect to a excel sheet as a datasource in the FM. My server (cognos) is in an offshore location and FM is on my machine. I followed the method here https://jazz.net/library/article/671. The excelsheet shows up in the FM. But whenever I 'test ' the data in any column, I get the following error message
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 'sqlPrepareWithOptions' status='-69'.
UDA-SQL-0043 The underlying database detected an error during processing the SQL request.
[Microsoft][ODBC Excel Driver] The Microsoft Access database engine could not find the object 'RI_Insurance_Premium'. Make sure the object exists and that you spell its name and the path name correctly. If 'RI_Insurance_Premium' is not a local object, check your network connection or contact the server administrator.
[Microsoft][ODBC Excel Driver]Invalid descriptor index
What could be causing this?
Thank you!
Hi Folks! I can see the sample test data now(in FM). Thank you!