November 16, 2004 at 7:06 pm
Re Edited -> some reason my post didnt post !!
The problem im having is an issue that seems to be getting worse
Basically on long running updates from an access 97 database to SQL server via code (not queries)
Upgrading to other versions of access (eg XP) dont fix the problem
the connection seemingly timesout about every 2-5 mins , i have run a trace on a machine causing the issue and it does actually loose the connection...however i have no idea why the connection is being dropped !!
anyone with any ideas/tools tests for me to run i would be very grateful
the client OS
MDAC is 2.7
client pc OS is XP professional SP1
Server is 2003 with SQL 2000 and we use NTAuth
Please any ideas on this is much appreciated as i am at a loss to explain, willing to post code/logs if it would help ?
Thanks
------------------------------
Life is far too important to be taken seriously
November 19, 2004 at 8:00 am
This was removed by the editor as SPAM
November 30, 2004 at 5:08 pm
Hi All,
Im assuming because no one has responded no one has a clue ?
even if its way off the mark im interested in trying anything !!
Cheers
Adam
------------------------------
Life is far too important to be taken seriously
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply