SqlServer.BatchParser not found

Topics: Database Publishing Wizard
Apr 23, 2007 at 9:04 PM
Hi,

When I run the Database Publishing Wizard from VWD and click next after selecting my database, I get the following error. I have no idea how to solve it. SQL Server Express appears to work fine. Running on Vista x64.

...Stefan

===================================

This wizard will close because it encountered the following error: (Microsoft SQL Server)

Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.ExecuteImmediate(String query)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.InitChildLevel(Urn levelFilter, ScriptingOptions so, Boolean forScripting)
at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.InitializeChildCollection(Boolean refresh)
at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.GetEnumerator()
at Microsoft.SqlServer.Management.SqlManagerUI.GenWizGeneralData.GetObjectsList(ScriptWizardPage pageId, Boolean onlyCheckCount, Boolean& exists)
at Microsoft.SqlServer.Management.SqlManagerUI.SelectDatabaseWizardPage.OnLeavePage(LeavePageEventArgs e)
at Microsoft.SqlServer.Management.UI.WizardPage.RaiseLeavePage(WizardButton button)
at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage nextPage)
at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender, EventArgs e)

Version info:

Microsoft SQL Server Management Studio Express 9.00.3042.00
Microsoft Data Access Components (MDAC) 6.0.6000.16386 (vista_rtm.061101-2205)
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.6000.16386
Microsoft .NET Framework 2.0.50727.312
Operating System 6.0.6000
Apr 24, 2007 at 2:23 AM
Hi Stefan

Do you know if you have the 64 bit version of SMO? If not, can you download the 64 bit version from http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_XMO_x64.msiand try again after installing it. Please let me know if you still run into issues after installing the 64 bit version.

Thanks
Himanshu

Apr 24, 2007 at 3:22 AM
Thanks, that solved it!

...Stefan
Jul 21, 2007 at 4:49 PM
Edited Jul 21, 2007 at 4:57 PM
I have Windows XP Sp2 X64 all updated as of 21 July 2007.
SQL Server Express SP2 64bit.
SQL Management Studio Express 64 Bit.
Sql Hosting Toolkit 1.1

I am getting the exact same error? I did have this working on Windows XP SP2 32bit no problems before.

Here is the error message:-

===================================

This wizard will close because it encountered the following error: (Microsoft SQL Server)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=MicrosoftSQLServerDatabasePublishing+Wizard&ProdVer=1.1.1.0&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

===================================

Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.ExecuteImmediate(String query)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.InitChildLevel(Urn levelFilter, ScriptingOptions so, Boolean forScripting)
at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.InitializeChildCollection(Boolean refresh)
at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.GetEnumerator()
at Microsoft.SqlServer.Management.SqlManagerUI.GenWizGeneralData.GetObjectsList(ScriptWizardPage pageId, Boolean onlyCheckCount, Boolean& exists)
at Microsoft.SqlServer.Management.SqlManagerUI.SelectDatabaseWizardPage.OnLeavePage(LeavePageEventArgs e)
at Microsoft.SqlServer.Management.UI.WizardPage.RaiseLeavePage(WizardButton button)
at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage nextPage)
at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender, EventArgs e)
Jul 21, 2007 at 5:03 PM
Err sorry it seems the SMO didn't install properly.

I tried again and it worked also