Hello,

I have also shifted from SQL2005 to SQL2008 and I had similar timeout problems.

Can you try these settings:

USYS$MSS_PARAMS = recsize=4000

Cheers

Johnny

UnifAce use other cusor types then MS-SQL :-(

Whenever you enter a SELECT in the (Microsoft)-SQL-Editor,  a non-update cursor-type is choosen by Microsoft.

UnifAce instead use allway an updatable cusror-type.

So the SQL-Editor can return the result-set faster then UnifAce, which runs (on big tables) into a timeout.

Ingo

Hi,

We have had luck with this MSS_PARAMS setting -

[DRIVER_SETTINGS]
MSS U4.0
USYS$MSS_PARAMS blah, blah, blah, maxlockwait:infinite
 

I was assuming you were also moving up to MSS 4.0 with your SQL migration.

Doug

Hmmm, is there a page somewhere which details the difference between MSS3.0 and MSS4.0?

Hi,

Another MS-SQL Connector option to try combining is

USYS$MSS_PARAMS step size = 100, procs=off, checks=off, identifiers=quoted, mapping:2, locktime:infinite, lock isolation:ru, hs:on, stmtcache:off, maxlockwait:infinite

Doug