Solved

Time out issue

Posted on 2013-06-19
6
316 Views
Last Modified: 2013-06-19
I have two different machines that are querying a backend database from Excel in EXACTLY the same way and on the same network.

One times out and the other doesn't.

Looking for suggestions on things to check.
0
Comment
Question by:patriotpacer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 2

Accepted Solution

by:
eli411 earned 500 total points
ID: 39260045
set the connection string timeout in config file!
0
 

Author Comment

by:patriotpacer
ID: 39260058
>>set the connection string timeout in config file!

Changing the query is not an option at this point.
0
 

Author Comment

by:patriotpacer
ID: 39260087
It's really 5 machines with NO issues and just one machine with an issue.

Wasn't sure if there's anything on the machine that doesn't work that could be checked?  Network card, etc...?
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 2

Expert Comment

by:eli411
ID: 39260248
Most likely is inside the coding with connection string opened.   The SQL Server automatically drop the connection to conserve resource and caused timeout.  I used to manage web servers and database servers and coding and had same issues.  I finally found that the issue was in my coding one day because I forget to close the connection in my coding.  

It is going to be painful to find that line of code or you can extending the SQL Server connection timeout setting!
0
 

Author Comment

by:patriotpacer
ID: 39260269
thx, Eli.

I agree the timeout issue can be extended.  But adjusting the code that connects is the last option at this point.

I want to know why 5 computers have no issues and only 1 computer has an issue.  All on the same network.  Again, only ONE will timeout.  The other 5 have absolutely ZERO issue running the EXACT same query and the exact same time.
0
 

Author Closing Comment

by:patriotpacer
ID: 39260463
don't have time to leave this open.

Might have to go down extending the time out route.
0

Featured Post

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Cross-Network Traffic 24 114
Powerline Adapter - Unidentified network 9 91
Outlook PST (cloud) backup 3 82
Create VM to talk to device connecting to PC 2 52
#Citrix #Citrix Netscaler #HTTP Compression #Load Balance
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

734 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