Hi. Periodically I need to run a delete statement that deletes old data. The problem is that this can timeout using ODBC (via the CDatabase and CRecordSet classes in legacy code). Also, while its running the delete, the table its operating on is locked and my application can't continue to run and operate on rows not affected by the delete.
Are there any workarounds for this? Can the timeout be set in the connect string?
Thanks,
Brian
No, you will have to set the timeout value on the appropiate command object.
Jens K. Suessmeyer
http://www.sqlserver2005.de
No comments:
Post a Comment