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.
| 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 2013ASPX with ReportViewer Control included on page.ReportViewer Control is pulling from a ObjectDataSourceReport (.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.aspxCodeFile="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.Selectinge.Command.CommandTimeout = ######End SubHowever, 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!! |
|
|
|
|
|
Objectdatasource / Table Adapter Command Time Out