Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 Objectdatasource / Table Adapter Command Time Out

Author  Topic 

sqlmjkm
Starting Member

14 Posts

Posted - 2014-09-24 : 04:16:08
Hello. I am not sure if this is posted in exactly the right place/new to this. I believe this is tied to SQL Reporting Services?.... Here is the background:

Visual Studio 2013
ASPX with ReportViewer Control included on page.
ReportViewer Control is pulling from a ObjectDataSource
Report (.rdlc file) is referencing back to a Dataset (.xsd file)
Dataset (.xsd file) includes the Table Adapter.
Page Language="VB"
ASPX File is named Default.aspx
CodeFile="Default.aspx.vb"

ObjectDataSources and SQLDataSources both have a default timeout of 30 Seconds. That is ok for most small select statements. However, for something a little larger - it could go over. I know how to override a SQLDataSource CommandTimeout. Something like this:

Protected Sub SqlDataSource1_WhatType_Selecting(sender As Object, e As SqlDataSourceSelectingEventArgs) Handles SqlDataSource1_WhatType.Selecting
e.Command.CommandTimeout = ######
End Sub

However, for a objectdatasource I am stumped. From the hours of research I have done - it seems to be tied back to the dataset or even the table adapter -- needs to be set there.

Anyways, I am starting over with this to see if anyone here has run in to this? Things to try?

Thank you!!
   

- Advertisement -