Solved

SQL Server "Communication Link Failure" problem

Posted on 1998-10-06
4
321 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

910 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now