Here's my setup:
But then when I try to place a database part, I only see 1 entry for each table...
For example, on MySQL here are all some of the capacitors:
Where as in Place Database Part, here's what I get:
Only the 1 entry. Same holds true for each table.
For sanity, I also accessed the table through MySQL Workbench in my VM. All rows are shown. However it should be noted I accessed MySQL through MySQL's own "Connect to Database" tool instead of using Windows' Data Sources.
Hoping you guys can provide some insight?
Ok, so as I was posting this I figured out the solution but figured it may be useful to someone in the future.
UPDATE YOUR DRIVERS. I reconnected using the MySQL ODBC 8.0 ANSI Driver and all is well.