Discussion board where members can get started with QlikView.
I have created user dsn but test connection failed.showing below error.
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 am using QWT file for using dsn.how to solve the issue.
Have you read these?
64bit QV, 32 bit office --- "Error: SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][OD...
That "mismatch" is very likely due to the fact that Windows has two tools to create ODBC connections with exactly the same name: ODBCAD32.exe, but
(folder locations may vary depending on your version of Windows).
Also, do not forget to click the "Force 32 Bit" checkbox in the script editor if your driver is the 32bit version.
Ok got it.thanks Miguel.