I wrote a database installer DLL to deploy the role based security files, based on the installer example on the forum. (DataProgress)

In my AppMain I added some code to check if the security database exists. If not, I automatically call the installer DLL.

Everything works perfectly when I run my application within visual studio, however, When I run the exe, I get the attached error.  The error occurs at the start of the data deployment phase.  The meta data is deployed without errors.

Any idea why this is happening?

Thanks

Tim

The only thing I can think to tell you is to make sure that the foreign keys are actually being turned off... since you're building the SF source code in debug, you can open the DatabaseMigrator file within the MicroFour StrataFrame DBEngine project and add a message box to the TurnOffAllForeignKeys() method to show the value of the DatabaseName parameter.  When you run, you should then get the message boxes for each database that is being included in the deployment.  If a database isn't included, then the foreign keys aren't being turned off and we have a problem somewhere.

Ben, I haven't had time to dig into this any further but I have run my deployment routine about 20 times so far and it seems to be hit and miss, sometime it works and sometimes I get the error.  After the error, I delete the Database and run the deployment again and it works fine.  Just thought I would pass this on in case it triggers something.

Thanks,

Tim