General information
Title:
Cursor adapters: Microsoft OLE DB Provider for SQL Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only