'Unable to connect to System DSN using Access 365
I have created a mySQL database on my webhosting site. I created an ODBC connection for it and I can access it fine with my client tool on my Windows 10 computer. When using Access 365 I can see ODBC connection tab for files and for machine databases but there is none for system DSNs so I can't connect to my MySQL database. Is there a way to force Access 365 to connect to system DSN?
Solution 1:[1]
Your system DSNs should show up under the Machine Data Source tab. Make sure you've created a 32 bit DSN for 32 bit Access or a 64 bit DSN for 64 bit Access.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | deluxeinformation |