CODEWITHSUNDEEP
sql-servervisual-studio-2010sql-server-express
Hossein
Hossein

Reputation: 25924

Can't create tables inside Visual Studio 2010, getting 'The specified module could not be found (exception from Hresult: 0x800700E)' error

I am trying to create a database and its tables using the Visual Studio 2010 Sp1 itself from server explorer section.

I could successfully create the database but when I go for the tables I get the error:

The specified module could not be found (exception from Hresult: 0x800700E)

I have SQL Server 2012 Enterprise installed on the system as well, and I'm trying to create the database inside visual studio using .\sqlexpress .

For the record: I had Visual Studio 2012 installed but removed it since I couldn't stand it. Does this have any relation to this problem?

How can I solve this problem?

Upvotes: 2

Views: 7847

Answers (3)

Smitha Nivesh
Smitha Nivesh

Reputation: 1

I have come across the same issue and wasted my time re-installing VS.

The solution is to simply replace the dsref80.dll file in the aforementioned directory, and still if it isn't working, restart your PC and copy is again from some a working system

Upvotes: 0

Barış Akkurt
Barış Akkurt

Reputation: 2256

Although, Hossein's answer is correct, I want to add that repairing Visual Studio 2010 didn't solve my problem. In addition to this, the file is at

C:\Program Files (x86)\Common Files\Microsoft Shared\Visual Database Tools

directory on my computer. I am using Windows 8. Just replace dsref80.dll at this directory with the file provided by Hossein.

Upvotes: 1

Hossein
Hossein

Reputation: 25924

OK i solved the problem . It was caused by the former installation of Visual Studio 2012 and then its un-installations. Visual Studio 2012 changes the dsref80.dll located at :

C:\Program Files (x86)\Common Files\microsoft shared\Visual Database Tools\

overwriting the older version. When it is uninstalled the dll remains though and since its version is newer and there is no more the version 10 , Visual studio 2010 generates an error. to resolve this problem all you need to do is to get the version 10 dll and place it in the mentioned path( a repair or re-installation would do the trick). here is the dll on my system if anyone needs it . Here is the source

dsref80.dll

Upvotes: 13

Related Questions