Small Business Starter Kit

Re: Using SQL instead of XML

newbie495 — Thu, 11 Jun 2009 02:22:39 GMT

I have SBSK running on my local machine and have tried using SQL Express by replacing xmlProvider with sqlProvider. Now I keep getting:

Server Error in '/Website1' Application.

Object reference not set to an instance of an object.

System.NullReferenceException: Object reference not set to an instance of an object.

Line 50: _provider = ProvidersHelper.InstantiateProvider(_providersSection.NewsProviders[_providersSection.NewsProviderName],

Any ideas??? Thank you.

Eddie

Re: Using SQL instead of XML

artistone — Fri, 17 Apr 2009 04:21:05 GMT

Hello

Are you using SQL server express or SQL Server 2005? Did you change anything else in the connection string? Did you make any modifications in the database, or attach the provided database in SQL? I'd be glad if you could guide me with step-by-step information because this is really breaking my head now.

Thanks

Sub

Re: Using SQL instead of XML

tman126 — Mon, 02 Apr 2007 22:42:55 GMT

Thanks,

After a while I saw the <SmallBusinessDataProviders peopleProviderName="sqlProvider" testimonialsProviderName="sqlProvider" catalogProviderName="sqlProvider" newsProviderName=""sqlProvider"> and it was ok.

Re: Using SQL instead of XML

figgie — Mon, 02 Apr 2007 21:56:45 GMT

I know I have seen this answered here before.

Need to go into your web.config and change providers from xmlpr

1    
2    <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
3      <!-- Register a new config section-->
4      <configSections>
5        <section name="SmallBusinessDataProviders" type="SmallBusinessDataProvidersSection" requirePermission="false"/>
6      </configSections>
7      <!-- Connection string, currently configured for SQL Express-->
8      <connectionStrings>
9        <remove name="SQLConnectionString"/>
10       <add name="SQLConnectionString" connectionString="Data Source=.\SQLExpress;integrated security=true;attachdbfilename=|DataDirectory|SmallCompanyDB.mdf;user instance=true"/>
11     </connectionStrings>
12     <!-- Register the providers and specify which ones to use for data access for each of the 4 pages-->
13      change these entries to SQLProvider<SmallBusinessDataProviders peopleProviderName="sqlProvider" testimonialsProviderName="sqlProvider" catalogProviderName="sqlProvider" newsProviderName=""sqlProvider">
14       <!-- Register providers for People - Similarly for other pages-->
15       <PeopleProviders>
16         <add name="sqlProvider" type="SqlPeopleProvider" connectionStringName="SQLConnectionString"/>
17         <add name="xmlProvider" type="XmlPeopleProvider" schemaFile="People.xsd" dataFile="People.xml"/>
18       </PeopleProviders>
19       <TestimonialsProviders>
20         <add name="sqlProvider" type="SqlTestimonialProvider" connectionStringName="SQLConnectionString"/>
21         <add name="xmlProvider" type="XmlTestimonialProvider" schemaFile="Testimonials.xsd" dataFile="Testimonials.xml"/>
22       </TestimonialsProviders>
23       <CatalogProviders>
24         <add name="sqlProvider" type="SqlCatalogProvider" connectionStringName="SQLConnectionString"/>
25         <add name="xmlProvider" type="XmlCatalogProvider" schemaFile="Products.xsd" dataFile="Products.xml"/>
26       </CatalogProviders>
27       <NewsProviders>
28         <add name="sqlProvider" type="SqlNewsProvider" connectionStringName="SQLConnectionString"/>
29         <add name="xmlProvider" type="XmlNewsProvider" schemaFile="News.xsd" dataFile="News.xml"/>
30       </NewsProviders>
31     </SmallBusinessDataProviders>
32     <system.web>
33   	  <compilation debug="false"/>
34       <customErrors mode="RemoteOnly" defaultRedirect="CustomError.aspx"/>
35       <pages theme="Standard"/>
36     </system.web>
37   </configuration>

ovider to sqlprovider and change all the commented stuf

Using SQL instead of XML

tman126 — Mon, 02 Apr 2007 18:43:24 GMT

Hello Everyone.

I downloaded the Small Business Starter Kit, and I need to use the news system. The provider that comes for default is the XML, but I wanted to be able to show data from the SQL News Table.

How can I turn off XML and use only the Sql tables in this starter kit.

Thanks

__________

TMAN