Jump to content
dcroghan

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

Recommended Posts

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

 

 

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×