ODBC subsystem error- cannot perform the connection to ODBC data source
Article # 3016422 - Page views: 355
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
NA