Data Source connects but linked server cannot initialize data source object in MS SQL Server
So after trying a ton of things with options in the driver, settings in the MSDASQL provider, etc. Replacing the MySQL ODBC driver with an older version worked immediately. This solved my issue. thanks!