Query Timeout in SDK

Automate and integrate using the SQL comparison API

Moderators: Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Query Timeout in SDK

Postby keithr » Thu Dec 19, 2013 11:44 pm

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
keithr
 
Posts: 8
Joined: Mon Nov 28, 2005 11:44 pm
Location: Mercer, PA, USA

Postby Brian Donahue » Mon Dec 23, 2013 3:15 pm

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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Comparison SDK 10

Who is online

Users browsing this forum: No registered users and 0 guests