I seem to keep getting this error when trying to create a connection between visual studio 2022 and Sql. (seems to work in VS 2019 when tested on my machine).

From the update Wizard when I click new connection:

when I leave everything as default Microsoft Sql Server as the data source and ".net framework data provider for SQL server" as the data provider.

when I hit continue I get the following error:

the connection properties then seems to load but when i hit OK i get another message:

I can't seem to get it to work.

I've tried updating to the lastest version of visual Studio as well as checking the machine.config for both the 64 bit and 32 bit instances of .net on my machine. As some others have suggested, but to no avail.

in both cases my machine.config looked like so:

<system.data>
           <DbProviderFactories/>
    </system.data>

I've tried removing the "DbProviderFactories" tag in both and restarted my machine but that didn't seem to make much difference.

<system.data>  </system.data>

I'm not sure if its normal for this to be blank. Perhaps I'm missing some components. but checking the Visual studio installer i seem to already have all the data components downloaded and installed.

Any help would be greatly appreciated.