error in data set connection RRS feed

  • General discussion

  • in visual studio when i try to add new data source using Microsoft OLEDB data base but in the IDE i cant select Provider=Microsoft.ACE.OLEDB.16.0  their is default value is Provider=Microsoft.ACE.OLEDB.12.0 plz help me
    Saturday, March 28, 2020 7:29 PM

All replies

  • A little late here but there is nothing in Microsoft.ACE.OLEDB.16.0 when working with DataSet/DataTable containers that Microsoft.ACE.OLEDB.12.0 does not have for working with databases. If this is for Excel than there may be other options but you have not indicated too much here to go on.

    Please remember to mark the replies as answers if they help and unmarked them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.

    NuGet BaseConnectionLibrary for database connections.

    profile for Karen Payne on Stack Exchange

    Thursday, April 9, 2020 2:02 PM