CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

 System.Data.OleDb.OleDbException: Timeout expired - Resolved

 Print topic Send topic

Author Message
rbaldwin

Posts: 172
Posted: 08/12/2010, 8:23 AM
my page times out after 30 seconds

my website and sql server are on single box for development but for production on separate boxes. ihave this problem in both situations.

i had this problem in the past and was able to get around it by tweaking my query.

but in this case that is no longer an option.

my SLQ server 2005 has the Remote query timeout set to 0 (unlimited)

in my project\App_Code\components\CodeCharge.Data.OleDb.vb

i have added following each
Dim Command statement a statement command.commandTimeout = 600

My connection string is:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=ip360Dashboard;Initial Catalog=ip360Dashboard;Data Source=10.40.2.67;Extended Properties="Connect Timeout=600"


Any suggestions?
View profile  Send private message
rbaldwin

Posts: 172
Posted: 08/16/2010, 8:32 AM
I resolved this by changing the provider in my connection string from Provider=SQLOLEDB.1 to Provider=SQLNCLI10.1
View profile  Send private message
joetraff

Posts: 2
Posted: 08/17/2010, 8:07 AM
Quote rbaldwin:
I resolved this by changing the provider in my connection string from Provider=SQLOLEDB.1 to Provider=SQLNCLI10.1
Good to hear that.
Keep us posted.
_________________
Thanks
View profile  Send private message
rbaldwin

Posts: 172
Posted: 08/17/2010, 8:21 AM
Support offered an additional suggestion, to add
dataSetAdapter.SelectCommand.CommandTimeout = 600
into RunSPImpl function.

To summarize edit
Common Riles/App_Code/CodeCharge.Data.OleDb.vb

following each Dim Command line and a new line
Command.CommandTimeout = 600 or some other # of seconds

Following the line containing
dataSetAdapter.SelectCommand = CreateCommand( .....
add a new line
dataSetAdapter.SelectCommand.CommandTimeout = 600
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.