Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

how to create user and system dsn?

Hi

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

3 Replies
Highlighted

Re: how to create user and system dsn?

Highlighted

Re: how to create user and system dsn?

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.

Highlighted
Creator
Creator

Re: how to create user and system dsn?

Ok got it.thanks Miguel.