Either you can change the runtime to 32bit in Visual Studio or install the 64 bit driver.

The last available 64-bit version of MySQL ODBC Driver is 8.0.33. You can find this version under the archive section. After installing this 64-bit driver, it will be accessible in the 64-bit ODBC window.

visual studio 2022 doesn't allow you to change the runtime to 32bit therefore thi is the only option i had to use the 64bit driver.