MSSQL model search fails due to timeout

[arose]

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?

[arose]

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

[dk]

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