ADO - MSSQL "Current Provider does not support necessary interface for index functionality"

[dcroghan 0]

Hello, 

My application uses a TAdoConnection and TAdoTable objects.

Delphi 10.4.1 reports the error "Current Provider does not support necessary interface for index functionality" when I try to assign an IndexName to a tadoTable object in design mode.  The tAdoConnection is currently active prior to assigning any properties to the tAdoTable.  The MS SQL Server is 2019.  The TAdoConnection is currently using the SQLOLEDB.1 provider.

 

This application did not previously have issue when compiled in Delphi 2010 and using SQL Server 2005 and the SQL Native Client provider.

 

Thanks you

 

 

[mobo 0]

Found a solution to this problem?