Red Gate forums :: View topic - Query Timeout in SDK
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK 10
SQL Comparison SDK 10 forum

Query Timeout in SDK

Search in SQL Comparison SDK 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
keithr



Joined: 28 Nov 2005
Posts: 8
Location: Mercer, PA, USA

PostPosted: Thu Dec 19, 2013 11:44 pm    Post subject: Query Timeout in SDK Reply with quote

I am using the SDK (v10) as part of our automated build utility. Previously, it had no issues with the connections when running the SaveToDisk method.

I am testing our build utility on a machine in another part of the network, and now I am getting time out issues when trying to create snapshots off some off the larger databases. (larger being relative, the databases with issues create snapshots about 2megs, while most are under 200k)

I've tried adjusting the timeout on the SQL Server side and this seemed to solve some of the timeouts, but I was wondering if there is a property I could set within the API, so the change can be restricted to when the snapshots are created.
_________________
Keith Rupert
Software Developer
Local Government Division
Tyler Technologies, Inc.
P: 888.654.3293 ext. 175111
www.tylertech.com
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Mon Dec 23, 2013 3:15 pm    Post subject: Reply with quote

Hello,

It depends on the type of timeout. If it's a timeout getting the initial connection to SQL Server (connection timeout), you can fool SDK into increasing the timeout by putting this after the server name (MYCOMP\MYSERVER;Connection Timeout=600) in the ConnectionProperties. If the problem is that during the registration, the metadata is not returned within the timeout (query timeout), there is no setting you can change because the query timeout is hardcoded at 600 seconds.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group