SQL Timeout with VC++ cRecordSet

I have a VC 6.00 app that adds a record to an SQL table using the cRecordSet class, usually it works but sometimes it throws a timeout exception, I cant seem to find a way of increasing this timeout, can anybody help?