>>Hello everyone,
>>
>>I have buil a cursor adapter wich runs a "heavy query" (around 40 secs in Server). I'm using ADO to connect to SQLServer2000. The cursor adapter is returning next message when CursorFill Method has been executed: Microsoft OLE DB Provider for SQL Server : Timeout Expired.
>>Notes: the ADO connection String in CA, includes the parameter Connect Timeout=0 (Unlimited).
>>Also the DB server (SQLServer) has been reconfigured for remote login timeout = 0 (Unlimited).
>>
>>Any idea migh help me a lot.
>>
>>Thank you in advance!
>>
>>Alexander Cubillos
>>Senior Analyst Programmer
>
>Hi Alexander,
>
>Try to set "Command Time Out" property (DBPROP_COMMANDTIMEOUT) for the ADODB.Recordset object.
>

I thought they tweaked that - but in re-reading the post - I do see they say connect time out - which would have no impact here.

I believe the default command timeout is 30 seconds - which would not be enough in this case.

Thanks for being a closer reader than I!!