Hello,
I have set up an ODBC connection in Cognos Connection for my datasource that I have set up in Microsoft Access as a link to an Excel spreadsheet. I have the ODBC connection set up on both my local PC since that is where I am running FM and on the Cognos server.
I have tested the connection in Cognos Connection and FM and both are successful. When I publish the package and try to run a report in Report Studio, I get the following message.
UDA-SQL-0107 A general exception has occurred during the operation "prepare". [Microsoft][ODBC Microsoft Access Driver] 'L:\Content\Excel Data\CognosDataDictionary Excel.xls'
I do have my drive mapped to L and that is where the Excel spreadsheet that is reference in Microsoft Access resides.
I am currently using Cognos version 8.1
Does anyone have any ideas?
Thanks