Hello,

I've got a very strange problem. I've got a web site which exepts an XML data document (400 Kb). This document is copied to the database server. Next the web server instantiates a Visual FoxPro DCOM component on the databse server which will do a bulkload of the data in de XML into several tables a SQL 2000 database. So far so good.
Next this component starts a stored procedure (via SQL pass through) which will start several stored procedures. Each of these stored procedures will walk through one table in the database and insert or update records in an other database.
Now my problem: sometimes (I don't know why or when) the stored procedure which processes the first table stops after 6 to 10 records (there are 123 records). I can't find why this happens. When I start the stored procedures from the query analyzer or via SQL pass through from the comand window there's no problem.
I allready set the connecttimeout to 600 seconds, but it doesn't help.
Has anyone seen this kind of behavior?

TIA,

Martin van Krieken