How to avoid the error "The specified DSN contains an architecture mismatch between the Driver and Application" when connecting to a client tool using TIBCO Data Virtualization ODBC driver?

How to avoid the error "The specified DSN contains an architecture mismatch between the Driver and Application" when connecting to a client tool using TIBCO Data Virtualization ODBC driver?

book

Article ID: KB0072839

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All supported versions

Description

When connecting to a client tool say RazorSQL, Excel, etc. using the TIBCO Data Virtualization ODBC driver, the user may sometimes come across this error:

User-added image

Issue/Introduction

This article will mention how to avoid the error "The specified DSN contains an architecture mismatch between the Driver and Application" when connecting to a client tool using TIBCO Data Virtualization ODBC driver.

Environment

Windows

Resolution

This happens because there is a mismatch between the version of the ODBC driver being used and the application.
For example, the application might be on a 32-bit version and the TDV ODBC driver is a 64-bit version or vice-versa.

Note: For any application connecting to TDV with the ODBC driver, only the same bit version can be used as that of the driver.