Change the default provider model to use SQL Server for SBS news, catalogs, testimonals

Last post 06-22-2008 4:31 PM by TinyPond. 1 replies.

Sort Posts:

  • Change the default provider model to use SQL Server for SBS news, catalogs, testimonals

    06-22-2008, 2:33 PM
    • Loading...
    • TinyPond
    • Joined on 07-28-2002, 6:39 PM
    • North West USA
    • Posts 57

    Hello All

     Where in the code/configuration  would I change the default Provider Model  to use SqlServer as the data source rather than XML

    I am talking about Catalogs, News, Testimonials they all use the XML Datasource, however in the provide sqlserver database these table are defined and I would like the example to default to these, however I cannot see where I would make this change. Is it in the web.config? if so what are the values?

     Thanks for you help in advance

    TinyPond
  • Re: Change the default provider model to use SQL Server for SBS news, catalogs, testimonals

    06-22-2008, 4:31 PM
    • Loading...
    • TinyPond
    • Joined on 07-28-2002, 6:39 PM
    • North West USA
    • Posts 57

     

     Change the provider in the web.config to either the SQLProvider or XMLProvider

    Web.config

    <!--
    Register the providers and specify which ones to use for data access for each of the 4 pages-->

    <SmallBusinessDataProviders peopleProviderName="SqlProvider" testimonialsProviderName="xmlProvider" catalogProviderName="SqlProvider" newsProviderName="SqlProvider">

    TinyPond
Page 1 of 1 (2 items)
Microsoft Communities
Page view counter