Unable to create tables in MSSQL on one machine, but can on another

[Paul Johnson]

Hi,

I have an ASP.NET project which relies on a database. I can do just about anything to the database except add tables. When I try to do that, I get the error

The specified module could not be found. (Exception from HRESULT: 0x8007007E)

This is about as helpful as the old BBC B "Mistake" error. Googling seems to have thrown up one of two problems WMI and SQL Server itself. I've tried the fixes suggested and I'm still getting the problem.

On another machine, I can add tables without a problem, commit to SVN and add the problem back to my laptop where the code is being developed.

Does anyone know how to trace this problem or just how to fix it?

Using VS2010 Ultimate, SQL Server R2 (SP1) and SQL Server Express 2008.

Thanks

Paul

[NeoPa]

I can appreciate the problem of trying to deal with an issue with so little basic information, Paul. I'm afraid you've left out both what your code is, and where the error message comes from. The question has been posted in the SQL forum, but my researches indicate it's a .NET library issue. I must admit it didn't sound like a SQL-type message, but who can know everything about SQL Server (not me to be sure).

If you can confirm that it's from the ASP.NET side of things I will happily move the question to the relevant forum. You may want to consider sharing the relevant part of your code with the experts there though, to make it easier for them to help you.

Alternatively, it may simply be a question of ensuring all libraries are up to date on that particular machine. I'll leave it with you anyway.

[Paul Johnson]

The error comes in VS when I try to add a table to my database. The connection is fine (tried that using the wizard) - as it's coming from when I try to do something with the database, I guessed this is the correct forum. If it's not, please feel free to shift it around a bit.

In the meantime, any clues on where to look for either a missing library or whatever else it could be?

[NeoPa]

Paul Johnson:
In the meantime, any clues on where to look for either a missing library or whatever else it could be?

I just put the full error message in the google field and sent it off.

I'm not an ASP or even a .NET coder, so I'm not the best to interpret that for you, but the impression I got was of a wrong version for a library file. I expect you'll be better able to understand what you get.

[Paul Johnson]

As I say, when I do that I get a pile of results pointing to WMI and SQL Server, but nothing that you can really stick your finger on and say "that's it"!

From what I've been told, it's quite a common problem

[NeoPa]

http://social.msdn.microsoft.com/For...-2cd17b446e29/ seems to imply that you need to look at your stack trace to determine which actual file is missing or of the wrong version, and explains what needs doing to fix it. I can't say I know where you'd look for that, as I don't even have such an environment available to me. I would assume that it's available somewhere, but I'm in no position to tell you where I'm afraid.

I'll move it across to ASP.NET and see what the folks there have to say.