Building a brand new Windows 2019 Server, with FME Server 2022.2.5. If we have workbenchs that write to SQL Server 2017 standard edition which ODBC Drive do we need (if any). My old server uses SQL Server Client, but my DBA says:
SQL Server Client was announced as deprecated and isn't recommended to be used. ODBC driver is the one to be used.
Hi @jhawks
For FME desktop/Server an OLEDB Driver for SQLServer is required.
Every FME Desktop/Server product is bundled with this package and typically gets extracted in C:\\FME\\FMEServer-21816win-x64-Installation-Files location (by default).
Can you check with your team if you have the package available?
Got it, and it's already been installed! thanks.
If you happen to install OLE DB Driver 19 for SQL Server there is a good chance you'll have issues with FME connecting to the SQL Server or Azure DB unless you still have the older OLE DB Driver 18 or less installed.
FME will revert to SQL Server 2012 Native Client if it is still installed and that will help with SQL Server DB's but for Azure you'll be blocked (at least in some cases) if you only have the OLE DB Driver 19 installed.
A ticket has been created to get support added to FME for v19 of this driver.
Update: Support for Microsoft OLE DB Driver 19 will be added for the FME 2023.0 release. It can now be tested in the most recent FME 2023 BETA release.