Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
MalcolmCICWF
Creator III
Creator III
‎2013-07-30 04:47 PM

Password Protected Excel

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?

Capture.PNG

634 Views
0 Likes
0 Replies