.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Microsoft.SqlServer.BatchParserClient, Version= -- Again it seems

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Ok I created a project and installer, the project uses the SMO assemblies.  On my system and all my test seems it installs and works fine.  After installing on other system I am starting to get error reports because "Microsoft.SqlServer.BatchParserClient, Version=" is not installed on the system.  I have been doing some digging and found the below link but that only seems to help after the fact.  I need to include the correct assemblies in my installer.  Currently the package include the list below which does not include the problem file.  I tried installing SP3 on SQL 2005 but that does not seem to have helped.  What is the correct way of getting this assembly installed on the client server.  I am not happy with giving everyone the below link.http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=228de03f-3b5a-428a-923f-58a033d316e1 Packaging file 'Microsoft.ReportViewer.Common.dll'... Packaging file 'Microsoft.ReportViewer.WinForms.dll'... Packaging file 'Microsoft.SqlServer.ServiceBrokerEnum.dll'... Packaging file 'WPFToolkit.dll'... Packaging file 'Microsoft.SqlServer.SqlClrProvider.dll'... Packaging file 'Microsoft.SqlServer.SqlEnum.dll'... Packaging file 'Microsoft.ReportViewer.ProcessingObjectModel.dll'... Packaging file 'Microsoft.SqlServer.ConnectionInfo.dll'... Packaging fil

View Complete Post

More Related Resource Links

Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=

Hello to everyone. I have a .exe which uses the Server Management Objects(SMO) When I try it on my pc it runs without any problem. But on another pc it gives this error: Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. I'm using SQL Server 2000 and for the application: Visual Studio 2005. Any idea would be very useful!! Thanks in advance!!

Problems with SMO 2008 Redist + Microsoft.SqlServer.BatchParserClient

Hi,    I'm trying to run my application using SMO 2008. Everything works just fine if i have sql 2008 server installed.   My problem starts when I try to use SMO 2008 Redist. First it does not install Microsoft.SqlServer.BatchParserClient or Microsoft.SqlServer.BatchParser. After a little research, I found that this is a problem and that these files have to be copied manually to the folder where the application runs.  So I tried copying the files: No luck, i get a Could not load file (Below).  Then i tried to adding these files to the GAC manually: Same thing, Could not load file:   Code Snippet Microsoft.SqlServer.Management.Smo.FailedOperationException: ExecuteNonQuery failed for Database 'DB2008'.  ---> System.IO.FileLoadException: Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=, 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)        Then I looked at the version of the files and they seemed to be version, so I went to my app.config and added a bind redirection from to now it finds the assembly but says that Manifest doesnt mach the reference:   Code SnippetMicrosoft.SqlServer.Management.Sm

Could not load file or assembly 'Microsoft.SqlServer.BatchParserClient'



I've seen several posts on this forum about this issue, and several have been resolved, but I'm not seeing the answer.

On my Windows 7 machine with SQL Server 2008 R2, I have a Visual Studio 2010 project that uses SQL SMO.

The app runs fine on my machine, but when I publish to another server, I get Could not load file or assembly 'Microsoft.SqlServer.BatchParserClient'

If I go to http://www.microsoft.com/downloads/en/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en

and install Microsoft SQL Server 2008 Native Client , Microsoft SQL Server System CLR Types , and Microsoft SQL Server 2008 Management Objects I stop getting the error.

It seems to me that I should just be able to properly reference what I need and deploy my project...

So- how do I deploy my project without needing these installs?


In His service,
Steve Gray MCDBA
Vice President, 4Penny.net
www.VSToolsForum.com - Dynamics GP development forum
www.devshed.us - Coding blog

Could not load file or assembly 'Microsoft.SqlServer.Diagnostics.STrace, Version=, Culture=


I am trying to use SQL Server 2008 Developer on Windows Server 2008.  Whenever I try to connect to the server, I get this error: "Could not load file or assembly 'Microsoft.SqlServer.Diagnostics.STrace, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified."

I found some info at http://blogs.msdn.com/b/ashishme/archive/2009/08/15/could-not-load-file-or-assembly-microsoft-sqlserver-diagnostics-strace-version-10-0-0-0-culture-neutral-publickeytoken-89845dcd8080cc91-or-one-of-its-dependencies-the-system-cannot-find-the-file-specified.aspx, but this didn't help me because it is not on my system, even after reinstalling both SQL Server and .NET Framework 4.  I also saw a this page: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/1115cd55-721d-4974-99b1-d142d1e6a927, but this also didn't fix my problem.

What can I do, or where can I get the missing assemble

Could not load file or assembly 'Microsoft.SqlServer.BatchParser' or one of its dependencies

I got this problem when I tried to migrate one of my web deployment project from vs2005 to vs2010 on windows 7 machine. The exactly error message is like this: Could not load file or assembly 'Microsoft.SqlServer.BatchParser' or one of its dependencies. An attempt was made to load a program with an incorrect format.(description) ASPNETCOMPILER(file), myWebDeploy (project) I have installed all of suggested feature packs as suggested by others: SQLServer2005_ADOMD_x64.msi, SQLServer2005_XMO_x64.msi. Can somebody please help? Thanks a lot 

What happened to the backup and restore classes in namespace Microsoft.SqlServer.Management.Smo vers

I do not see these two classes in version 10 of this namespace and I am not finding any documentation explaining what happened to them.

Powershell script that uses Microsoft.SqlServer.Management.Smo.Server need to use Sql Server Autheni

I have written a powershell script that uses Microsoft.SqlServer.Management.Smo.Server.  I have a couple of instances that are on different domains that I must use Sql Server authenication.  I am going to create a report user "sssmorpt".  What is the least a can grant this user to allow me to use Microsoft.SqlServer.Management.Smo.Server to get "$dbsize = $db.size - ($db.logfiles|measure-object -property size -sum).sum / 1024" for all databases in an instances?

Getting "wrong" data out of a microsoft.sqlserver.management.smo.database object property (using pow

My problem:I do something like this:$dbsvr = new-object microsoft.sqlserver.management.smo.server "servername"$dbsvr.databases | ft name,size -autosizeWhen i run this from two different PC's i get database sizes that are all the same (5.25 mb), the size of the first database listed - which is master.I started to try out a few things, and found out that when i run the same command from one of our servers it returns the correct sizes...Anyone have any idea if this a SMO issue, or maybe some package software version issue...- or what?

Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: No description found

Hi, I'm getting the following error: Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: No description found  when I try and add a excel connection manager to a package being generated programmatically.   I'm working with SQL Server 2008 SP1 (64bit) and Microsoft Office 2007 Data Components (32bit) on a Windows Server 2008 R2 (64bit) The code is executed by a WCF service hosted on IIS7 with the app pool running in 32bit mode. Since this is the 4th environment on which the app is being deployed and the only one that throws the error, I don't think it's an actual problem with the code. One thing that could be significant is that the new box I'm trying to deploy my app to is a VMWare virtual machine whereas all the others are physical servers. What could possibly throw this error? It's very non-descript :( Any suggestions and ideas would be greatly appreciated.

Could not load file or assembly 'Microsoft.Scripting.ExtensionAttribute, Version=

Dear ASP.NET I keep getting this strange error (below) on my local machine on the first time the page loads, Then if I reload it - it loads correctly... What is really strange is that it does not happen on the server (same settings)   I'm using AJAXControlToolkit.dll version 4.1.40412.2 and this script manager (if not I get the Common.Common.js error)<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="AJAX" %> <AJAX:ToolkitScriptManager runat="server" ID="_scriptManager" AsyncPostBackTimeout="600" EnablePartialRendering="true" EnableHistory="true" />   I also tried to add this: <runtime> <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"> <dependentAssembly> <assemblyIdentity name="Microsoft.Scripting.ExtensionAttribute" publicKeyToken="28f01b0e84b6d53e"/> <bindingRedirect oldVersion="" newVersion=""/> </dependentAssembly> <dependentAssembly> <assemblyIdentity name="AjaxControlToolkit" publicKeyToken="31bf3856ad364e35"/> <bindingRedirect oldVersion="" newVersion="4.1.40412.0"/> </depende

0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

64 bit Server 2003 with Sql 2005 64-bit I can't seem to do a lot of things.  Like... backup the database through the SQL agent.I'm catching flak from the client who was told by a microsoft rep that SQL 2005 works like a charm....It's too late to move away from SQL 2005, we've already migrated systems over to it, and now I'm stuck.This error happens when trying to export to a flat file using Export Wizard(right click database and choose export):===================================An error occurred which the SQL Server Integration Services Wizard was not prepared to handle. (SQL Server Import and Export Wizard)===================================Exception has been thrown by the target of an invocation. (mscorlib)------------------------------Program Location:   at System.RuntimeMethodHandle._InvokeConstructor(Object[] args, SignatureStruct& signature, IntPtr declaringType)   at System.RuntimeMethodHandle.InvokeConstructor(Object[] args, SignatureStruct signature, RuntimeTypeHandle declaringType)   at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)   at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)   at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[]

Framework error:Could not load file or assembly 'Microsoft.AnalysisServices, Version=

Hi,I use sql clr sp's to load data in to database using .net framework 2.0. I never had aproblem using this and it went well for months.I recently updated to net framework 3.5 sp1 and sqlserver sp3 on 32-bit sql server and win 2003.I am facing an error which i could not resolve.Error:System.IO.FileLoadException: Could not load file or assembly 'Microsoft.AnalysisServices, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050)System.IO.FileLoadException:    at StoredProcedures.checktable(String paramComponent, String paramParameters)I have gone through different forums, and trie different options,but did not help. I am using 'unsafe'  option.I also tried to alter assembly which is mentioned in http://support.microsoft.com/kb/949080/pt But when i tried to alter the assembly using the above link or try to change the permission to external access on the assembly, i get the below error.Alter ASSEMBLY AccessibilityFROM 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Accessibility.dll'Cannot alter the assembly 'Accessibility', because it does not exist or you do not have permission.I am an admin on the server/sqlCan some one suggest how to alter assembly with permissions or solve this issue or am i missing anything important.Do i

A question about Microsoft.SqlServer.SqlParser.dll

Hi all, I found this library in SSMS 2008 assemblies, it can parse T-SQL statements into structured XML as well.  'Microsoft.SqlServer.SqlParser.Parser.Parser.Parse(SQL)' This function can resolve standard select/update/insert statements, and it's very useful to us for advance code policies check,  but it's not for all sql commands, for example: 'CREATE TABLE' is okay to go, but 'ALTER TABLE' is not. why? And one thing more, after SQL Server 2008 R2 is installed, this assembly disappeared.:( Is it a half-done job? Where can I find the final version?

Microsoft.SqlServer.Dts and related assemblies to develop custom ssis task are missing

Hi All, I tried to develop a simple ssis task but the problem that I can't refer the necessary assemblies like Microsoft.SqlServer.Dts.Runtime And also Microsoft.SqlServer.DTSPipelineWrap Microsoft.Sqlserver.DTSRuntimeWrap Microsoft.Sqlserver.ManagedDTS Microsoft.SqlServer.PipelineHost What is certan that they aren't installed within the GAC in my case, so where could I find them? I have SQL server 2008 entrprise edition Other question, should I use Microsoft.SqlServer.Dts.Design and  Microsoft.SqlServer.ManagedDTS which are missed too, or they are part of the 2005 version only Thank you   The complexity resides in the simplicity

Microsoft.NET version 3.0 Install Error: Installation failed for Windows Communication Foundation. M

Please help! I've been trying for the last day and a half to properly install Microsoft.NET version 3.5 so that I can install TurboTax and do my taxes. I was only on version 1.1. Multiple tries to upgrade to 3.5 was giving me a code 1603 error on install on "Microsoft.NET version 2.0a". I followed advice from forums here and elsewhere to uninstall and reinstall my prior versions. I also used Windows Install Cleanup before reinstalling. I keep getting to the same result when I try to go from version 2.0 to version 3.5. In my last attempt, I went all the way back to version 1.0 and installed each step up to 2.0 SP1 with (allegedly) no problems. This last time I decided to upgrade to 3.0 instead of going right to 3.5. Now I get the following error message: [04/03/10,04:07:14] Windows Communication Foundation: [2] Error: Installation failed for component Windows Communication Foundation. MSI returned error code 1603[04/03/10,04:07:22] WapUI: [2] DepCheck indicates Windows Communication Foundation is not installed.[04/03/10,04:07:22] WapUI: [2] DepCheck indicates Microsoft .NET Framework 3.0 was not attempted to be installed.[04/03/10,04:17:49] Windows Communication Foundation: [2] Error: Installation failed for component Windows Communication Foundation. MSI returned error code 1603[04/03/10,04:17:57] WapUI: [2] DepCheck indicates Windows Communication Foundati

Security Update for Microsoft .NET Framework, Version 1.1 Service Pack 1 (KB928366)

I have been trying to install   Security Update for Microsoft .NET Framework, Version 1.1 Service Pack 1 (KB928366)   since it was released but downloads ok but it will not install. Everytime installation of this update fails!   Help...

newbie in Java .... java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

Hi All, I am new to java, trying to learn and understand. I downloaded the 2008 R2 SQL server Express, Downloaded the JDBC jar file, unzipped it. and set class_path accordingly in environmental variables. C:\Program Files\Microsoft SQL Server JDBC Driver\sqljdbc_3.0\enu\sqljdbc.jar, C:\Program Files\Microsoft SQL Server JDBC Driver\sqljdbc_3.0\enu\sqljdbc4.jar Also I have added the sqljdbc_auth.dll in the system32 file as most of the content suggested. I tried running a simple program that microsoft has provided . I have not advanced to programs such as eclipse and others, I am using a simple textpad to write and see if it connects the way it is supposed to . I hope you can guide me through the process. My TCP/IP is enabled, dynamic ip is left to blank, I can successfully telnet to 1433 port . Am I doing something wrong or am I missing a step somewhere   import java.*; public class Connect{      private java.sql.Connection  con = null;      private final String url = "jdbc:microsoft:sqlserver://";      private final String serverName= "localhost";      private final String portNumber = "1433";      private final String databaseName= "Banking";      private final String userName = "sa";   &nb
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend