Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: arose on April 17, 2008, 05:32:04 am

Title: MSSQL model search fails due to timeout
Post by: arose on April 17, 2008, 05:32:04 am

I have build a certain model search query that I am using with a large MSSQL repository.  The connection string is:
"ea_bigdb --- DBType=1;Connect=Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=EA_bigdb;Data Source=<servername>"

The query times out after 40 seconds.  Adding "Connect Timeout=90" or "Connect Timeout=0" makes no difference - the query still fails after 40 seconds.

If I copy the connect string to a UDL file, modify it using the data link properties dialog box, specifying a connect timeout value, the connect timeout value is not stored in the UDL file. I had thought that the property "Connect Timeout" is a valid property of the sqloledb provider.

How can I adjust the query timeout for an MSSQL repository?

Title: Re: MSSQL model search fails due to timeout
Post by: arose on August 25, 2008, 11:22:50 am

The inability to specify a timeout for MSSQL forced me to redesign the query, which a should probably have done anyway, since it now runs in about 10-15 seconds :-)

Allan

Title: Re: MSSQL model search fails due to timeout
Post by: dk on September 07, 2008, 02:00:16 am

As far as I know "Connect Timeout=90" is the time to wait for a successful connection not the query timeout.