ansaurus

Question

Can't find microsoft.sqlserver.batchparser.dll

Answer 1

+1 A:

To get this dll, you will need to install the Microsoft SQL Server 2008 Management Objects (available from here). That particular dll gets installed into the GAC, which is why you probably cannot find it using a search.

As you are using a hosting provider, it would appear that they do not have this installed. Your choices are to get it installed by them (which is probably unlikely), or deploy the dll manually (which may be on dodgy licencing ground).

adrianbanks 2010-10-20 18:54:32

When I try to install SMO, the installer says I already have a higher version installed. Since I am able to reference Microsoft.SqlServer.Smo from my project, I guess this confirms it.

Nicolas Cadilhac 2010-10-20 19:09:35

@Nicolas: yes, you will have this installed locally. It is not however installed on your hosting provider, hence the problem you are having.

adrianbanks 2010-10-20 19:11:15

Calling gacutil /l shows me batchparser is in the GAC, however the references dialog box in VS2010 won't show it to me. Going manually into the GAC to extract the assembly and it is in the GAC_32 folder, not GAC_MSIL. Anyway, adding this to Reflector shows it has a reference to Microsoft.VisualC.... pretty odd.

Nicolas Cadilhac 2010-10-20 19:15:12

@Nicolas: according to [this](http://blogs.msdn.com/b/mwories/archive/2005/05/02/smofaq.aspx) page, that particular dll is platform-specific (ie. there are both 32 and 64 bit versions).

adrianbanks 2010-10-20 19:21:43

I have no idea how to deploy SMO on my hosting provider... See my other comment in the other answer (for the GAC). I can't install the latest "Microsoft SQL Server 2008 Feature Pack, April 2009" either (hoping to find redistributable package inside) because it always complain I have something newer already installed

Nicolas Cadilhac 2010-10-20 19:59:02

@Nicolas: You could manually extract the dll from the msi (instructions [here](http://www.adrianbanks.co.uk/?p=64)) and deploy that, but I'm not sure what the licencing implications are.

adrianbanks 2010-10-20 22:12:40

Answer 2

A:

You need to have the SMO components installed on your hosting provider as well. You can download them here.

Joe Stefanelli 2010-10-20 18:59:05

Well, obviously I can't install an msi on a shared host. Let me call them to know what they say about SMO.

Nicolas Cadilhac 2010-10-20 19:20:53

discountasp won't install that, so does it mean I have to extract the dll + its dependency (Microsoft.VisualC) and put it in my bin folder?

Nicolas Cadilhac 2010-10-20 19:49:41

ansaurus

tags:

views:

answers:

Can't find microsoft.sqlserver.batchparser.dll

related questions