)
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. (Last updated on: June 24, 2019).
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

Platform: Dashboard Platform |
Control: Dashboard SDK |
Published Date: February 20, 2018 |
Last Revised Date: May 7, 2019

Increasing time-out for embedded Dashboard using SQL server database connection

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 -->

 

 

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

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

Live Chat Icon For mobile
Live Chat Icon