topic how to create user and system dsn? in QlikView

how to create user and system dsn?

gkcchowdary — Wed, 25 Nov 2020 16:16:04 GMT

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.

Thanks

chaitanya

Re: how to create user and system dsn?

settu_periasamy — Thu, 14 Dec 2017 05:34:41 GMT

Hi,

Have you read these?

64bit QV, 32 bit office --- "Error: SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] T…

Re: how to create user and system dsn?

Miguel_Angel_Baeyens — Thu, 14 Dec 2017 07:17:38 GMT

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

If your driver (not the computer!) is built for 32bit, you need to use C:\Windows\SysWoW64\odbcad32.exe
If your driver is built for 64bit, use C:\Windows\System32\odbcad32.exe

(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.

Re: how to create user and system dsn?

gkcchowdary — Thu, 14 Dec 2017 08:15:53 GMT

Ok got it.thanks Miguel.