Jump to content


Photo
- - - - -

MSDE connection error


1 reply to this topic

#1 LukeNeet

LukeNeet

    Member

  • Members
  • PipPip
  • 10 posts
  • Gender:Male

Posted 12 September 2008 - 10:15 AM

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.

#2 Neil Hunter

Neil Hunter

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 414 posts
  • 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



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users