HI All,

Has anyone had a problem where MSSQL would give an error "communication link failure" when doing a batch delete or insert.
We are using MSDE, lookup, change, add is no problem. When trying to do a buld delete or insert into a table this error pops up.
We are using windows Server 2003 R2, Proiv 5.5 rev 345. Client 5.5 build 524.

We moved this customer from an old server to a new (faster , newer) Server. the old Server was running SQL 2000. There was no problem on the old server.

Luke, have you tried upgrading the kernel to a later version of 5.5?

I gather you are using the 2003 ODBC driver?

Also look at increasing the ODBC timeout. Have a couple of customers with 5.5 and SQL 2003 haven't had the issues you speak of