Loading

The database or data provider you selected is not supported

Priyanka Kumari

I have added sql server .mdf file in my project,when i am clicking on it to add table,it throws above error.

I am using Visual Studio 2010 and Sql Server 2008.

Any help will be highly appreciated.

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Priyanka Kumari8y ago
I have copied both mdf and log file as well
+1
Piyush Pansuriya8y ago
Hello,
Make sure you have copied both mdf and log file as well.
+2
Priyanka Kumari8y ago
I have tried by attaching mf file from C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA

but it throws same error
+1
Amit Kumar8y ago
Hi
go to which directory where SqlServer create mdf & ldf file and keep it inside this location and then attach it
if you are using sqlserver 2012 or 2014 then
C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA
+1