Solved

SQL Server "Communication Link Failure" problem

Posted on 1998-10-06
4
330 Views
Last Modified: 2012-05-04
I have an application written using VB 4 and connected to SQL server 6.5 SP4 through RDO 2.0.  (and ODBC 3.0).  The application is running OK except if I leave the application on and do nothing around 20 minutes and then back on again (for example, press a button to retrieve data) an ODBC  SQL driver error "Communication link failure" appear on the screen and I could not get any data.  I looked for the query timeout factor within the registry under ODBC but the timeout value is already quite generous..
Can someone give me a clue what's happening, please?  
0
Comment
Question by:waiman
  • 2
  • 2
4 Comments
 
LVL 2

Accepted Solution

by:
connex earned 100 total points
ID: 1090421
There is also a timout-value in the configuration of the SQL-Server. If a connection is idle longer than that value the
SQL-Server ends the connection.

If you application is most likely idle for a longer time
i suggest closing the connection and reopen it when you need it.

0
 

Author Comment

by:waiman
ID: 1090422
I checked the server configuration.  "Remote conn timeout" is set to 10.  Is it the right parameter and if it is, what should be the right figure?
0
 
LVL 2

Expert Comment

by:connex
ID: 1090423
Exactly that is the parameter. If you want to diasable it at all enter -1.
Else give the amount in minutes after that the server should
close idle connections.

0
 

Author Comment

by:waiman
ID: 1090424
I'll try that out first and I'll return to you later.  I'm going to be on holiday this month so I would hold this for a while but I'll let you guys know the progress next month then I will rate the answers.  Thanks a lot.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question