none
could not load Microsoft.Sqlserver.SqlEnum, Version = 10.0.0.0 RRS feed

  • Question

  • Hello,

             I am getting the Exception at Client site when trying to syncronize the two SQL Server 2005 databases. The Exception is "Could not load file or assembly 'Microsoft.SqlServer.SqlEnum, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified." Why I am getting this error? How to resolve this?

    I am able to do it at my development machine.

    The Client envirnment :

    OS : Microsoft Windows Server 2003 R2  Standard x64 Edition  Service Pack 1.

    SQL Server : SqlServer 2005

    I tried to installing 'SQLServer2005_XMO_x64.msi' from http://www.microsoft.com/downloads/en/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en    but no luck :(.

     

    Please help me. I have demo to client on 9th Sept.

     

    -Ajinath

     

     

     

     

    Wednesday, September 8, 2010 12:16 PM

Answers

  • I installed SP2 and the Sync Framework 2.0 SDK which resolved the problem.

     

     

    -Ajinath

    • Marked as answer by JuneTModerator Wednesday, September 15, 2010 3:02 PM
    Wednesday, September 15, 2010 10:33 AM

All replies

  • Wednesday, September 8, 2010 2:12 PM
    Moderator
  • Thanks for the reply.

    There are many more links. Which one I need to download and install?

    Your help is appreciated.

     

     

    -Ajinath

     

     

    Wednesday, September 8, 2010 2:35 PM
  • Microsoft SQL Server 2008 Management Objects

     

    Wednesday, September 8, 2010 2:43 PM
    Moderator
  • I installed this but no luck. I copied the Microsoft.Sqlserver.SqlEnum from development machine to the client. But now it is saying could not load file or assembly 'Microsoft.Sqlserver.BatchParser'.

     

    Please help :( .

     

    -Ajinath

     

    Wednesday, September 8, 2010 3:15 PM
  • try installing this as well Microsoft SQL Server System CLR Types.

    btw, what's your dev environment? what's your project's target platform under the Project Properties->Build

    Wednesday, September 8, 2010 3:49 PM
    Moderator
  • I installed Microsoft SQL Server CLR types as well, but throws same exception of Could not load Microsoft.Sqlserver.BatchParser.

    My Development environment is :

    OS : Windows 7 Professional

    Visual Studio 2010.

    Project's Target Platform is - Any CPU.

    Target Framework is - .Net Framework 4.

     

    Thanks

    -Ajinath

    Thursday, September 9, 2010 4:22 AM
  • can you verify your applications bin folder if you have any SQL Server specific assemblies there?

    btw, does your app directly references those assemblies?

    other things you might do is target the app to 32-bit or 64-bit and make sure you install the corresponding 32 or 64bit components of SQL 2005.

    Thursday, September 9, 2010 4:35 AM
    Moderator
  • Yes. I have used 1.) Microsoft.SqlServer.ConnectionInfo.dll, 2.) Microsoft.SqlServer.Management.Sdk.Sfc.dll, 3.) Microsoft.SqlServer.Smo.dll and are directly referneced in my project. I have alredy deployed these dll along with my app.

    As the OS is 64 bit, I think I need to build the project with target as x64. Can you please give me some more information about 'make sure you install the corresponding 32 or 64bit components of SQL 2005'

    Thanks very much JuneT for looking inot this and prompt response.

    Waiting for your valuable response.

     

    -Ajinath

    Thursday, September 9, 2010 5:08 AM
  • Hi JuneT,

                 I changed the target platform to x64 and it worked. millions of THANKS.

    Now I am getting the error as 'Retrieving the COM class factory for component with CLSID {046C184F-2188-4C99-A95A-9C0DCDC19050} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).'

    Any idea about this?

     

    Thanks again.

     

    -Ajinath

    Thursday, September 9, 2010 5:21 AM
  • check the stack trace to find out which component is firing the exception and verify that you have deployed the 64bit version of that component as well.
    Thursday, September 9, 2010 5:39 AM
    Moderator
  • Hi,

        I found that the SqlServer 2005 SP1 is installed there and the Sync Framework Database Providers require Sql Server 2005 SP2, so installing the SP2 at client site.

    If this resolves the issue I'll let you know.

    Thanks.

    -Ajinath

    Thursday, September 9, 2010 6:06 AM
  • I installed SP2 and the Sync Framework 2.0 SDK which resolved the problem.

     

     

    -Ajinath

    • Marked as answer by JuneTModerator Wednesday, September 15, 2010 3:02 PM
    Wednesday, September 15, 2010 10:33 AM