"External exception C0000006" occurs & don't know why

[LucieLastic]

hi All

I've wrote a DLL in Delphi 7 which uses ADO to access a Sql Server 2000 database. This DLL is used by a Turbo Basic app running on citrix. Occassionally this error occurs ("External exception C0000006") but nothing appears in the SQL Server log. The Basic app pauses for about an hour or so and succeeds on the 2nd attempt. This error doesn't happen every time so difficult to pinpoint what it could be. I've done a Google search but couldn't find anything. Has anyone experienced this problem and can shine any light on it?

many thanks for help
lou

 

[EricDraven]

Is your DLL releaing its memory correctly? Ive had a similar problem in the past which was memory related.

[blue]Well ain't this place a geographical oddity. Two weeks from everywhere![/blue]

 

[LucieLastic]

hi Eric

I believe it is freeing memory properly but I will double check and run further tests. This DLL is used 'all over the shop' on many different Turbo Basic apps and they are all ok. The error is new, too - the app (with the error) has been running with this DLL for quite some time and it's only recently appeared.

lou

 

[LucieLastic]

I have re-Googled and found some articles on this problem, don't know why I didn't find them before.

It appears that this error is caused by a network interruption or a connection being dropped. 'Could even be caused by a flaky cable or connector somehwere to cause this. If it's dropping packets, it can cause file corruption as well as this C0000006 error'.

We have added a loop in the Basic code so it will attempt to connect every minute up to 10 times, so hopefully this may get round the problem.

lou