November 6, 2003 at 12:48 am
hi
I have a connection object in visual basic 6 which is automatically being disconneced whenever i perform a updatebatch from a recordset.the recordset has about 50000 records.what could be causing this disconnection.I tried setting the CommandTimeOut property on the connection object but that still doesnt work.Could it be the FileGrowth property of my database in SQL Server 2000.
November 10, 2003 at 6:10 pm
File growth won't break the connection directly, potentially could case a timeout if it took long enough (or long enough in concert with the update). Do you get an error message when the connection drops?
Andy
November 10, 2003 at 11:45 pm
thanks for the response Andy.I sorted out the problem tho.I was doing 2 updatebatch routines from 2 diffrent recordsets which seemd to cause the connection failure.I changed my table structure a bit to perform only one updatebatch .Thanx again
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply