StrataFrame Forum

Error loading Microsoft.SqlServer.Smo....

http://forum.strataframe.net/Topic20795.aspx

By Edhy Rijo - 11/18/2008

Hi,

I am testing a new installation on a clean Virtual PC which will not have MS-SQL installed on that workstation and I am getting the following error:

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

Source     : MicroFour StrataFrame UI

Stack Trace:
   at MicroFour.StrataFrame.DBEngine.SQL.SQLServerSchema..ctor()
   at MicroFour.StrataFrame.Data.SQLServerConnectionPage..ctor()
   at MicroFour.StrataFrame.Data.ConnectionWizard.LoadRequiredPages()
   at MicroFour.StrataFrame.Data.ConnectionWizard..ctor(RequiredDataSourceCollection RequiredItems, Int32 ApplicationPK, Boolean PersistData)
   at MicroFour.StrataFrame.Data.ConnectionWizard..ctor(RequiredDataSourceCollection RequiredItems, Int32 ApplicationPK)
   at MicroFour.StrataFrame.Data.ConnectionManager.ShowConnectionWizard(Int32 ApplicationPK)
   at MicroFour.StrataFrame.Data.ConnectionManager.SetConnections()
   at FixTrack.AppMain.SetDataSources()
   at MicroFour.StrataFrame.Application.StrataFrameApplication.Raise_SetDataSources()
   at MicroFour.StrataFrame.Application.StrataFrameApplication.RunApplication()
   at FixTrack.AppMain.Main()

In my install script I am including the file SQLSMOMergeModule.msm as listed on the SF help file.

My dev computer is Vista Ultimate 64bits but the installation is builded as 32bit. 

What am I missing here?

Again, the workstation will not have the database installed, only my application.

By Ivan George Borges - 11/18/2008

Hi Edhy.

These are the assemblies that my install package is adding to the GAC:

By Edhy Rijo - 11/18/2008

Thanks Ivan, those where the missing files.  The SF help file does not mention any of those files as a requirements for distribution, so I guess the help needs to be updated in this regard.

Now the help do mention the need for the SQLSMOMergeModule.msm which I was in the believe that this merge file should have take care of the files you mentioned here.

By Ivan George Borges - 11/18/2008

Yeah, well... if I remember (which would be a miracle), I googled SMO Assemblies to get a list of those.

Anyway, glad it helped you! Cool

Hope everything is fine with you guys up there.