StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



Click Once SQL 2008 SMO objectsExpand / Collapse
Author
Message
Posted 05/18/2009 5:11:32 AM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: Forum Members
Last Login: 05/18/2009 5:48:27 AM
Posts: 1, Visits: 3
We have recently moved to VS2008 and SQL 2008 from VS2005 and SQL 2005.

I have a problem when we deploy our click once application, the following message is displayed

Unable to install or run the application. The application requires that assembly Microsoft.SqlServer.Dmf Version 10.0.0.0 be installed in the Global Assembly Cache (GAC) first.

The assembly is included in the deployment files, but as far as I am aware Click Once cannot deploy directly to the GAC. The issue seems to stem from the Microsoft.SqlServer.Smo assembly which is referenced in the Strataframe DBEngine and UI assemblies. Our application does not reference any SQLServer assemblies directly.

Do you have any ideas on how we can deploy these assemblies through click once?

Post #23157
Posted 05/18/2009 6:30:24 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: 08/31/2010 2:36:53 PM
Posts: 6,287, Visits: 6,191
As you can probably find on other threads, I am not a fan of ClickOnce and so we abandoned it long ago.  However, this is just a SQL Server SMO 10 assembly reference.  In the most recent version of SF (1.6.7) we have removed all SMO references from all projects EXCEPT the dbengine as this is what is used for database deployment through the DDT.  The error that it is giving you, do you get this when you are trying to build the package or when you are trying to deploy the package?  In either case, it is just a matter of loading the SMO assemblies.  We actually have an MSM that we distribute with SF to help with this.  You can find it in the c:\program files\MicroFour\StrataFrame\Distribution\SQLSMOMergeModule.msm path.  This includes all of the SMO assemblies required for distribution.  If ClickOnce will not support MSM files, then you can also download the SMO 10 MSI redistributable from Microsoft's website.
Post #23158
Posted 05/18/2009 10:39:14 AM
Strategic Support Team Member

Strategic Support Team Member

Group: StrataFrame Developers
Last Login: Yesterday @ 6:46:55 PM
Posts: 1,880, Visits: 5,732
If you are actually using the dbengine from SF, then you'll need to use the prerequisites feature of ClickOnce to get the SQL DLL loaded into the GAC. However, likely you aren't actually using this in your app and you just need to uncheck this as a required file in the ClickOnce (publish) area.
Post #23174
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Dustin Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 8:40am

Powered by InstantForum.NET v4.1.4 © 2010
Execution: 0.047. 9 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.