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.
Click the link below to see the new game I'm developing!
1 reply to this topic
#2
Neil Hunter
-
- Members
-
- 420 posts
ProIV Guru
- Gender:Male
- Location:Johannesburg, South Africa
Posted 12 September 2008 - 10:39 AM
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
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
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
Click the link below to see the new game I'm developing!
