I have an Excel sheet being loaded into a Qlikview report. We had to add a password protection due to some issues and I cannot get the report to pull from it anymore.
I founda thread about setting up the ODBC connection to connect, but I having issues getting this to work as explain. I keep getting the message when I got the the select wizard:
Connection Test Failed
SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
I set the below ODBC up and pointed to the workbook, I have the report open prior as suggested in the posts I read and I am using Excel 2007. Am I not setting the initial ODBC up correctly?