We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to increase the timeout for a data source with SQL Server database connection in an embedded dashboard

This article explains how to increase the time-out and allow multiple connections for a SQL Server database which is used as a data source connection for the embedded dashboard.

Refer to the user guide, how to change the connection string in embedded dashboard at run time and follow the given steps:

  1. Configure the connection string to increase the connection time-out and define the pool size. For example, if the data source connection of the embedded dashboard is SQL Server database, then the connection string can be framed as,

"Data Source = <server name>; User ID =<username>; Password = <password>; Initial Catalog =<database name>; Connect Timeout=200; Pooling=true; Max Pool Size=200"

OR

  1. Configure the connection string to allow multiple connections to bring the result set with multiple tables/views or Stored Procedure/SQL Query as input for your data source connection. For example, if the data source connection of the embedded dashboard is SQL Server, then the connection string can be framed as,

"Data Source = <server name>; User ID =<username>; Password = <password>; Initial Catalog =<database name>; MultipleActiveResultSets=True"

OR

  1. Configure the connection string to increase the time-out and allow multiple result set at a time, then frame the connection string as,

"Data Source = <server name>; User ID =<username>; Password = <password>; Initial Catalog =<database name>; MultipleActiveResultSets=True;Connect Timeout=200; Pooling=true; Max Pool Size=200"

 

  1. Also, make sure you have configured the enough execution time in IIS (Web.config file) where the embedded dashboard was deployed (or hosted). For example, <httpRuntime executionTimeout="180" /> <!--Time in seconds -->

 

 

Article ID: Published Date: Last Revised Date: Platform: Control:
8459 02/20/2018 02/20/2018 Dashboard Platform Dashboard SDK
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon