Having recently disabled older SSL & TLS versions on our servers, fme desktop/server sql connections have broken. The workaround for other applications was installing OLE DB v19. I've tested this using a blank .udl file and confirmed it works creating a db connection with v19 but not the other.
How do i get fme desktop/server to recognize this new version? As the error still suggests its using the basic oledb driver.
The connection string fme complains about i think should have'provider' set to MSOLEDBSQL19 instead of just MSOLEDBSQL
Any suggestions are appreciated! 🙂