Versions Compared

Old Version 5

changes.mady.by.user Unknown User (emoke.olti)

Saved on

compared with

New Version 6

changes.mady.by.user Unknown User (emoke.olti)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

UI Expand
title.NET

Use the following steps to configure the datasource:

  • Configuring the database connection for the Reporting SQL Store component in .Net is done by adding a connection configuration to the Web.config file:

    Example configuration:

    Code Block
    title.NET database configuration example
    <hibernate-configuration>
  <session-factories>
    <session-factory name="ReportingDao">
      <properties>
        <property name="connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />
        <property name="dialect" value="NHibernate.Dialect.MsSqlCeDialect" />
        <property name="connection.driver_class" value="NHibernate.Driver.SqlServerCeDriver" />
        <property name="connection.connection_string" value="Data Source=|DataDirectory|\LocalDB\ReportingDB.sdf" />
        <property name="show_sql" value="false" />
        <property name="current_session_context_class" value="Aquima.WebApplication.WebPersistenceUtility.Session.CurrentHibernateSessionContext, WebPersistenceUtility" />
      </properties>
    </session-factory>
  </session-factories>
</hibernate-configuration>

  • In Studio the previously configured connection name needs to be used as the Connection parameter of the AQ_Report service
    In the previous example the name of the connection is ReportingDao.

All necessary DLL files the Reporting SQL Store component depends on can be found in the /bin directory of the .NET webapp ZIP file.