Using SMO and ClickOnce deployment

Hot Topic

Default Data Directory and Access Upsizing
Help understanding stored procs
Running 2000 and 2005 Reporting services on a single server
Server Tag not well formed error
The subscription to publication is Invalid
How to launch a SSIS package from VB or whatever
Datafields in report header
How to create an SSIS package correctly by programming?
task reusability
SQL Server 2005 Reporting Services Configuration

SQL Server

I can't dissable a dimension level
String to Date Conversions
Win CE 4.2 and Smart Dev Application question
Having a drilldown report "go back" to original report
Select Distinct Problem
"Using Object Data Sources in a Report" - for Web Apps? (VS 2005)
SQL SERVER EXPRESS 2005
Data Comparison Question
How robust is Reporting Services 2005
MS SQL Server 2000 Enterprise Edition installation error

Using SMO and ClickOnce deployment

Hi,

I'm writing an app that I want to use ClickOnce deployment with. The app may have to ask the user for the Server and Database name to connect to if it is the first time it has been run. I'm thinking of using Sql SMO but I see the requirements for this include MDAC 9.0.

Can anyone tell me how this could affect a clickonce deployed app I'm no export with clickonce, sorry. I'm hopeing it is possible to deploy MDAC 9.0 via clickonce too.

Any help would be great.

Graham

Answer this question

Using SMO and ClickOnce deployment

  • kubilay

    Is there a redist avaiable If not, what is needed to install SMO on a system Is it sufficient to install the Microsoft.Sql.* assemblies into the GAC Or do I need to do some other setup


  • Harry Miller - MSFT

    Hi Graham, SMO does not have a requirement on MDAC9.0.

    Of course SMO needs to be installed on the target system. If that is not the case there will be a SMO redist available that your clients can install.

  • Alex Cane

    Hi Graham,
    You might want to check out the blog post I did on this recently that I think answers your questions:
    http://www.softinsight.com/bnoyes/PermaLink.aspx guid=55e06d89-7245-42a3-b149-17ecc9369ed0

    Brian
    brian.noyes@idesign.net

  • nalsur8

    Thanks for the info Michiel.

    I got the MDAC 9 requirements from the MSDN docs but hey, if it doesn't need it then great!

    The redist that wil be available, does anyone know if this can be installed via clickonce, or canit be at least 'advertised' on the click once install page

    Graham

  • WXU

    See the ClickOnce FAQ (or click here for an answer to your question).

    [The FAQ loads a little slow BTW]



  • Using SMO and ClickOnce deployment
Answer this question