Hello,

I've customized the SampleDataInstallerClass solution and now need to build a Setup.exe for distribution.

I've created an InstallShield basic MSI project and have included the following:

SQLSMOMergeModule.msm (not sure what files are included and where they end up)

In the [CommonFiles]\MicroFour\StrataFrame\ folder I'm including these files:

MicroFour StrataFrame Base.dll

MicroFour StrataFrame Business.dll

MicroFour StrataFrame DBEngine.dll

MicroFour StrataFrame UI.dll

[update] I mistakenly listed the inherited UI DLL instead of the base UI

When I install these via the compiled Setup.exe, the files end up on the target workstation, but the SampleDataInstallerClass EXE does not run. When I launch it, I see the EXE in task manager for a second or two, then it goes away.

What I'm missing?

Thanks.

Bill

This Setup.exe doesn't have an "application" folder, it's just being used to install the SF DLL's and SMO's needed to run the SampleDataInstallerClass EXE on the workstation.

The application EXE will be run from a network location.

One more thing, the application EXE does run on a workstation with the SF development environment.

Hi William,

I build the SampleDataInstallerClass into my application's main assembly (.exe), and I don't run anything from a network patch since some .NET programs may need custom security settings to be able to run from a network path.

I install my application locally in each workstation and my logic is that any workstation can update the database structure from the main application which I control access to it via the RBS.

Edhy Rijo

When I copy the application EXE to the local desktop, I'm getting the same results, the process shows up in task manager for a few seconds, then goes away.

This is part of the code to run my version of this class, in my case DataProgress.vb

Dim DDTPackageName As String = "InsuranceBrokerSystemDDT.pkg"
Dim DDTPackagePassword As String = "MyPassword"
Dim loDataUpdateProgress As New DataProgress(MicroFour.StrataFrame.Data.DataLayer.DataSources("").ConnectionString(), DDTPackageName, DDTPackagePassword, DataDeploymentOptions)
loDataUpdateProgress.TopMost = True
UpdateDatabase = loDataUpdateProgress.ShowDialog()
loDataUpdateProgress.Close()
loDataUpdateProgress.Dispose()

Please post the code you are using show the form?

Edhy Rijo