Skip to main content
www.usoft.com To www.usoft.com

After the upgrade from USoft 9.1 to USoft 10, we get this warning message (several times) whenever we start a component (Definer, Application, etc.):

MSOLEDBSQL driver not found, fallback to SQLNCLI11

HResult of 1 returned

This did not happen with USoft 9.1 using the same SQL Server 2016 database.

Anyone know what the cause might be?

This is a functionality that has changed in USoft 10. USoft 9.1 was using the SQLNCLI11, USoft 10 uses the preferred MSOLEDBSQL. When connecting via MSOLEDBSQL fails USoft 10 falls back on SQLNCLI11 and informs the user about it. More information on SQLNCLI11 and MSOLEDBSQL can be read here:

https://docs.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server?view=sql-server-ver15

It is possible that MSOLEDBSQL is not installed on the computer. In that case read the following article:

https://docs.microsoft.com/en-us/sql/connect/oledb/applications/installing-oledb-driver-for-sql-server?view=sql-server-ver15

That was easy, thanks :grinning: !

Reply


Terms & ConditionsCookie settings