Error loading Microsoft.SqlServer.Smo....


Author
Message
Edhy Rijo
E
StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
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.

Edhy Rijo

Ivan George Borges
Ivan George Borges
Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Hi Edhy.

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


Edhy Rijo
E
StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
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.

Edhy Rijo

Ivan George Borges
Ivan George Borges
Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
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.

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search