Posted By: kulkarna | Jan 19th, 2006 @ 7:59 AM
page 1 of 1
Comments: 2 | Views: 6632
Hello-

My web application communicates with both SQL Server 2000 as well as  SQL Server 2005. In the "bin" folder of my web application I have included the following 2  dlls that are necessary for the SQL Server 2005:
1) Microsoft.SqlServer.BatchParser.dll
2) Microsoft.SqlServer.Replication.dll

Everything works fine when I invoke one of the asmx (web services) in  my web application on a SQL SErver 2005; but when I invoke that service  on a SQL Server 2000  box then it erros out with the following message.

As a remedy, I've tried putting all the Microsoft.SqlServer.*.dll in
the GAC for the SQL Server 2000 machine, but in vain.
Any ideas on what I am missing?
Thanks!

Error:

This application has failed to start because the application
configuration is incorrect. Reinstalling the application may fix this
problem. (Exception from HRESULT: 0x800736B1)
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem.

(Exception from HRESULT: 0x800736B1)

Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.

Stack Trace:

[COMException (0x800736b1): This application has failed to start
because the application configuration is incorrect. Reinstalling the
application may fix this problem. (Exception from HRESULT: 0x800736B1)]

[FileLoadException: Could not load file or assembly
'Microsoft.SqlServer.Replication, Version=9.0.242.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91' or one of its dependencies. This
application has failed to start because the application configuration
is incorrect. Reinstalling the application may fix this problem.
(Exception from HRESULT: 0x800736B1)]
   System.Reflection.Assembly.nLoad(AssemblyName fileName, String
codeBase, Evidence assemblySecurity, Assembly locationHint,
StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean
forIntrospection) +0
   System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef,
Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean
forIntrospection) +211
   System.Reflection.Assembly.InternalLoad(String assemblyString,
Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean
forIntrospection) +141
   System.Reflection.Assembly.Load(String assemblyString) +25

System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String
assemblyName, Boolean starDirective) +32

[ConfigurationErrorsException: Could not load file or assembly
'Microsoft.SqlServer.Replication, Version=9.0.242.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91' or one of its dependencies. This
application has failed to start because the application configuration
is incorrect. Reinstalling the application may fix this problem.
(Exception from HRESULT: 0x800736B1)]

System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String
assemblyName, Boolean starDirective) +596

System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory()
+3479081

System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo
ai) +46

System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection
compConfig) +177
   System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath
configPath, Boolean supportLocalization, String outputAssemblyName)
+180

System.Web.Compilation.CodeDirectoryCompiler.GetCodeDirectoryAssembly(Virtu

alPath
virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet
excludedSubdirectories, Boolean isDirectoryAllowed) +347
   System.Web.Compilation.BuildManager.CompileCodeDirectory(VirtualPath
virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet
excludedSubdirectories) +125
   System.Web.Compilation.BuildManager.CompileCodeDirectories() +525
   System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled()
+448

blowdart
blowdart
Peek-a-boo
kulkarna wrote:
Hello-

My web application communicates with both SQL Server 2000 as well as  SQL Server 2005. In the "bin" folder of my web application I have included the following 2  dlls that are necessary for the SQL Server 2005:
1) Microsoft.SqlServer.BatchParser.dll
2) Microsoft.SqlServer.Replication.dll

Everything works fine when I invoke one of the asmx (web services) in  my web application on a SQL SErver 2005; but when I invoke that service  on a SQL Server 2000  box then it erros out with the following message.



Thats not unsurprising, those assemblies are part of the SQL install are they not? So they will be replying on having an active SQL2005 instance there.


If this problem still persists then you may consider visiting

http://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en

You would need to install

Microsoft Core XML Services (MSXML) 6.0
Microsoft SQL Server Native Client

Microsoft SQL Server 2005 Management Objects Collection

I had a similar problem deploying and running an application that used RMO to set up replication between two SQL server 2000 databases.

Installing the three packages have resolved all the issues.
page 1 of 1
Comments: 2 | Views: 6632
Microsoft Communities