StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Error loading Microsoft.SqlServer.Smo....

Error loading Microsoft.SqlServer.Smo....

Edhy Rijo — Tue, 18 Nov 2008 16:41:39 GMT

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:

[codesnippet][code]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()
[/code][/codesnippet]

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.

RE: Error loading Microsoft.SqlServer.Smo....

Ivan George Borges — Tue, 18 Nov 2008 16:41:39 GMT

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.

RE: Error loading Microsoft.SqlServer.Smo....

Edhy Rijo — Tue, 18 Nov 2008 16:31:09 GMT

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.

RE: Error loading Microsoft.SqlServer.Smo....

Ivan George Borges — Tue, 18 Nov 2008 16:11:24 GMT

Hi Edhy.

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