ODBC subsystem error- cannot perform the connection to ODBC data source

Last updated
Save as PDF

Trying to configure the ODBC source in data filter on a 64but machine and you get the following error message:

UNKNOWN MESSAGE^Data Filter: ODBC subsystem error: cannot perform the connection to ODBC data source. Status: -1. Data Filter procedure: testing connection (Lookup in DB filter's operation). Diagnostics: .

Resolution / Workaround

Go to Start
Open Computer
Open your C: drive
Select the Windows folder
Select the SysWOW64 Folder
Search for ODBCAD32 executable
Right click and RUN AS ADMIN
Configure your SYSTEM DSN
Run a test

Path: C:\Windows\SysWOW64