how to create user and system dsn?

[gkcchowdary]

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

[settu_periasamy]

Hi,

Have you read these?

64bit QV, 32 bit office --- "Error: SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][OD...

[Miguel_Angel_Baeyens]

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.

[gkcchowdary]

Ok got it.thanks Miguel.