asp.netsql server
Receiving below error message in Visual Studio 2008 while creating a connection for database.
could not load file or assembly
'microsoft.sqlserver.management.sdk.sfc ,Version=10.0.0.0,
Culture=neutral,PublicKeyToken=89845dcd8080cc91' or one of its dependencies.
The system cannot find the file specified.
I am trying to create database internally i.e. .mdf file and store it in the App_data folder.
But I'm not able to create the connection.
Please help me to sort out the issue quickly.
The answer by baldy below is correct, but you may also need to enable 32-bit applications in your AppPool.
Whilst setting up an application to run on my local machine (running Vista 64bit) I encountered this error:
Could not load file or assembly
ChilkatDotNet2or one of its dependencies. An attempt was made to load a program with an incorrect format.
Obviously, the application uses ChilKat components, but it would seem that the version we are using, is only the 32bit version.
To resolve this error, I set my app pool in IIS to allow 32bit applications. Open up IIS Manager, right click on the app pool, and select Advanced Settings (See below)
Then set "Enable 32-bit Applications" to True.
All done!
NOTE: This answer is for people who are using MS SQL SMO (Management Objects) from a C# program.
I was struggling with the error mentioned in the question. The exact error I got was this:
Could not load file or assembly 'Microsoft.SqlServer.BatchParser.dll' or one of its dependencies. A dynamic link library (DLL) initialization routine failed. (Exception from HRESULT: 0x8007045A)
It ended up to be a problem with running .NET 2.0 assemblies within .NET 4.0 (or higher) CLR. The SQL server SMO assemblies are built against v2.0.50727 of the runtime and hence the following section is required in the app.config (or web.config)
<startup useLegacyV2RuntimeActivationPolicy="true">
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
</startup>
The hint was in this discussion thread on MSDN forums.
Best Answer
You can download these files from Microsoft website.
1.Microsoft SQL Server System CLR Types
2.Microsoft SQL Server 2008 Management Objects
3.Microsoft SQL Server 2008 Native Client.
After installing the above three files try to connect your application with sql server database and if still you got the same error message then don't worry and close your application then start it again and you will be able to connect it.