Communication link failure

[sqlwp]

When accessing a database with Crystal in design mode when I run the report the first time it runs fine, and if I keep running it within a few minutes it's fine, but if I let the report sit there for more than a few minutes when I try to run it again I receive a "communication link failure" and have to close Crystal and re-open it to run again. I'm using ODBC to access the database with tcp/ip. There are no timeouts set on the database. Any ideas? This does not happen from all PC's. The only difference I can see between the PC's is that one that works has a static IP, the other doesn't.

 

[synapsevampire]

Which version of Crystal, ODBC driver and database? Technical information is usually helpful when posting.

The error does sound more network related than driver, have you tested other network connectivity when it fails to make sure that they can still hit the WEB, LAN, etc.?

-k

 

[sqlwp]

Its SQL 7.0 database. I've tried it with Crystal 9 and Seagate Info 7.5 and it fails on both. The driver is SQL 2000.85.1022.00. (2/20/2003).
Other network connectivity is fine, no other application fails. PC's that have the problem and that don't both have the same version of Crystal, same ODBC driver, same mdac version. It does seem server/db related because the only server it happens on is a server that's in the DMZ, not on the LAN.