64bit QV, 32 bit office --- "Error: SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"

Fri, 23 Nov 2012 16:11:57 GMT

HI,

I have installed 64bit QV Personal Ed, 64bit Windows 7 and 32bit Ms Office. When I open Script Editor and loads Ms Access file thru ODBC Connect and select MS Access Database it gives an error

"Error: SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"

Is there any solution without cahnging Ms office to 64bit version? Becase I have an excel add-in that works only on 32-bit version. So I dont want to lose that add-in also.

Also I have designed a QV app on 64bit QV version, if I moved to 32bit QV, would it work on it?

Please advise.

Thanks and regards

Shoaib Ahmed

Re: 64bit QV, 32 bit office --- "Error: SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"

Tue, 12 Mar 2013 21:15:47 GMT

Hi Shoaib

Please check the box at the botton left corner called "Force 32 bit" and it should work fine as it did for me

thanks

faiq

topic 64bit QV, 32 bit office --- "Error: SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application" in QlikView

64bit QV, 32 bit office --- "Error: SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"

Re: 64bit QV, 32 bit office --- "Error: SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"