Can't open DBML files - .Net data provider missing?
I have installed Visual Studio 2017 on a new computer, and I am trying to work on my C# project which uses LINQ. Previously, I have worked with Visual Studio 2017 on a Windows 7 machine with SQL Server 2012. Now I need to switch to Windows 10 and SQL Server 2017.
I have installed Windows 10, SQL Server 2017 and Visual Studio 2017 Professional. In the setup of Visual Studio, I activated "LINQ to SQL tools" as well as "SQL Tools".
The project loads and I can actually compile and run everything.
But when I try to open a DBML file in the IDE, I get several error messages:
"Der Extenderprovider konnte keinen Extender für dieses Objekt zurückgeben." (Translated: "The extender provider could not return an extender for this object")
as well as
"Der angeforderte .Net Framework-Datenprovider kann nicht gefunden werden. Er ist ggf. nicht installiert" (Translated: "The requested .Net Framework data provider can not be found. It is probably not installed")
Other problem (probably same origin):
When I try to add a data source and select "Microsoft SQL Server", I receive the message:
"Das Verbindungseigenschaftenobjekt muss vom Typ SqlConnectionProperties oder OleDBSqlConnectionProperties sein." (Translated: "The connection property object must be of type SqlConnectionProperties or OleDBSqlConnectionProperties")
In the drop box I can select ".NET Framework-Datenanbieter für SQL" and ".NET Framework-Datenanbieter für OLE DB" Both don't work.
Here is a screenshot of my setup
It turned out that I had to changed the machine.config file ( %windir%\Microsoft.NET\Framework64\(version)\config\machine.config ) and remove the extra line <DbProviderFactories/>. This solves both problem plus a third problem where I couldn't use the View-Designer in SQL Management Studio.
Update: This issue still happens with a fresh installation of Visual Studio 2022! It's amazing that Microsoft doesn't fix this showstopper after nearly 4 years.
- Simple frame by frame video decoder library
- GCC no longer implements <varargs.h>
- Contents of IO buffer unknown == unsafe?
- Avoiding strcpy overflow destination warning
- Sort program not working, not sure why
- Fast & accurate atan/arctan approximation algorithm
- What's the difference between strtok_r and strtok_s in C?
- How memory address for pointer to arrays is same as an element in 2D array?
- Which is the best way to suppress "unused variable" warning
- How to use ellipsis in c's case statement?
- How can I exclude non-numeric keys? CS50 Caesar Pset2
- Fast ceiling of an integer division in C / C++
- Is there an invalid pthread_t id?
- How to Implement Universal Setter/Getter Functions for Interrupt-Driven Variables in Embedded C?
- How does SIMD (avx) processing work? for example, if I want 10 32 bit floats how do i fit in a 256 bit avx vector?
- FDCAN problems on STM32G4
- How does the call macro enable mutual recursion between functions f and g in this Hanoi Tower implementation?
- Running test on Rocket core CPU - global variable initialized to 0 is unsuccessful, output wrong value instead
- Interacting with C arrays without knowing the size
- Combination of two strings
- carriage return by fgets
- How to use special characters in C?
- Why does 1.0/100.0 == 0.1/10.0 give True?
- Is it correct to compare pointers in C?
- Force free() to return malloc memory back to OS
- How can I print to standard error in C with 'printf'?
- What is the standard behavior of fread in C on Windows?
- How is strtok removing lines it shouldn't have access to?
- Using array as smart point in C
- Assigning string to malloced 2d char array not working as intended