Skip to main content

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

Article # 3016422 - Page views: 437

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

Other Information