Hi @Anonymous ,
According to the information what you provided, please refer to You encounter error messages when you execute linked server queries without the required providers installed, see below:
• The installed OLEDB provider's bitness does not match the bitness of SQL Server. For example, you may have installed 32 bit version of the provider but SQL Server is running in 64 bit mode.
If it is not work, could you please provide the error log (C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log)? You can search "error" in error log to get the details. And also, please provide the version of SQL Server and the server which you would like to link (select @@VERSION).
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.