By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,068 Members | 1,210 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,068 IT Pros & Developers. It's quick & easy.

Timeout

P: n/a
I am setting the source of a crystal report and sometimes get a Timeout
error.
How can I increase the timeout?
It seems to timeout after 30 seconds.

Here is a snippet of the code that I use.
Using VB 2005

Dim oRpt As New ReportDocument
Dim strConnectionString As String = "Data Source=Server1;Initial
Catalog=Database1;Persist Security Info=True;User ID=test;Password=password"
Dim conn As New SqlConnection(strConnectionString)
Dim strSQL as String = "SELECT * FROM Table1"

Dim DS As New Data.DataSet
Dim DA As New SqlDataAdapter(strSQL, conn)

DA.Fill(DS)

oRpt.Load(Application.StartupPath.ToString &
"\Reports\pc_detail_employee.rpt")
oRpt.SetDataSource(DS.Tables(0))

Thanks,
Lou
Apr 19 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Add Connection Timeout = Whatever at the end of the connection string.
"Lou Civitella" <lo*@webersystems.com> wrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
I am setting the source of a crystal report and sometimes get a Timeout
error.
How can I increase the timeout?
It seems to timeout after 30 seconds.

Here is a snippet of the code that I use.
Using VB 2005

Dim oRpt As New ReportDocument
Dim strConnectionString As String = "Data Source=Server1;Initial
Catalog=Database1;Persist Security Info=True;User
ID=test;Password=password"
Dim conn As New SqlConnection(strConnectionString)
Dim strSQL as String = "SELECT * FROM Table1"

Dim DS As New Data.DataSet
Dim DA As New SqlDataAdapter(strSQL, conn)

DA.Fill(DS)

oRpt.Load(Application.StartupPath.ToString &
"\Reports\pc_detail_employee.rpt")
oRpt.SetDataSource(DS.Tables(0))

Thanks,
Lou

Apr 19 '06 #2

P: n/a
Before the fill, do:

DA.SelectCommand.CommandTimeout = ??

Replace the '??' with whatever value you feel is appropriate. You can use 0
for an infinite timeout.

"Lou Civitella" <lo*@webersystems.com> wrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
I am setting the source of a crystal report and sometimes get a Timeout
error.
How can I increase the timeout?
It seems to timeout after 30 seconds.

Here is a snippet of the code that I use.
Using VB 2005

Dim oRpt As New ReportDocument
Dim strConnectionString As String = "Data Source=Server1;Initial
Catalog=Database1;Persist Security Info=True;User
ID=test;Password=password"
Dim conn As New SqlConnection(strConnectionString)
Dim strSQL as String = "SELECT * FROM Table1"

Dim DS As New Data.DataSet
Dim DA As New SqlDataAdapter(strSQL, conn)

DA.Fill(DS)

oRpt.Load(Application.StartupPath.ToString &
"\Reports\pc_detail_employee.rpt")
oRpt.SetDataSource(DS.Tables(0))

Thanks,
Lou

Apr 19 '06 #3

P: n/a
> Add Connection Timeout = Whatever at the end of the connection string.

As long as it is a value and more than 0 'or you would like rusian roulette

http://msdn2.microsoft.com/en-us/lib...ontimeout.aspx

Cor
Apr 19 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.