ODBC is quite useful for application access routines, especially for professional users. And, seemingly, there are a plethora of ODBC issues for Windows 10 users who either moved from Windows 7 or upgraded their Windows 10 version to the latest release.
If you’re one of them and having certain issues with ODBC on Windows 10, check the solutions below.
How to fix ODBC issues on Windows 10
- Remove SMBv1 and enable SMBv2/SMBv3)
- Check Windows Firewall and Windows Defender
- Update drivers
- Rollback to the previous Windows version
Solution 1 – Remove SMBv1 and enable SMBv2/SMBv3)
Some users resolved the problem by disabling SMBv1 and enabling SMBv2 or SMBv3. This can be done in various ways, starting with the PowerShell or Registry Editor. The latter way is faster and more simple but might affect your PC negatively if misused. So, before following the steps below, make sure to back up your registry.
Here’s how to disable SMBv1 and enable SMBv2/SMBv3:
- In the Windows Search bar, type regedit and open Registry Editor.
- Navigate to Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters.
- Right-click on the empty space and create a new Dword, name it SMB1, and set its value to 0.
- Right-click on the empty space and create a new Dword, name it SMB2, and set its value to 1.
- Exit Registry Editor and restart your PC.
Do this on every affected machine and don’t forget to reboot it in order for changes to be applied.
Solution 2 – Check Windows Firewall and Windows Defender
Some users managed to resolve the problem by simply whitelisting or temporarily disabling Windows Firewall and enabling Windows Defender. This is a long-shot solution, but it’s worth a try. If you already have a third-party antivirus, try combining it with the native antivirus.
After that, reboot your machine and try accessing the ODBC application again.
Solution 3 – Update drivers to fix Windows 10 ODBC issues
In case you’re running a 32bit Office on a 64bit machine over ODBC, you’ll need some reconfiguring in order to avoid driver errors. Or, rather, accessing the ODBC32 version instead of the standard 64bit present on the x64 architecture.
Here’s where to find it and how to run it:
- Navigate to C:WindowssysWOW64odbcad32.exe and run it. It’s the 32bit ODBC Data Source Administrator.
- Try applying drivers again.
- After you’ve applied drivers, restart your PC.
Solution 4 – Rollback to the previous Windows version
As many of the affected users said, the problem emerged after they updated Windows 10 to the version 1803. The same can be applied to 1809. And, instead of waiting for Microsoft to address ODBC issues in their current release, we rather suggest rolling back to the previous version where the service was fully functional.
- READ ALSO: Fix: Blue screen after Windows 10 rollback
Here’s how to roll to a previous version of Windows 10:
- Open Settings.
- Choose Update & Security.
- Select Recovery from the left pane.
- Click on “Go back to the previous version of Windows 10“.
- Click on Get started and follow instructions.
RELATED STORIES YOU SHOULD CHECK OUT:
- Fix Windows 10 File Corruption Issues
- Full Guide: FILE SYSTEM error in Windows 10
- Operation did not complete successfully because the file contains a virus