Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

TCP/IP Connections & ODBC Errors

Posted on 2013-06-26
3
Medium Priority
?
423 Views
Last Modified: 2013-06-28
Hi Experts,

I am using Win7 Pro PC as a SQL server with SQL 2008 Express R2. This serves a local database application to about 6-7 workstations.

Time to time, I get random ODBC errors, which I believe gets worst at busy times, sometime restarting the application helps temporarily, but a bigger relief is when I shutdown everything, restart the server, then start everything up again.

I have read that Win 7 is limited to 20 concurent TCP/IP connections and i am thinking that ODBC is related to this because when I open a particulat form in my application, I have my main recordset, but I also have around 5 or 6 dropdowns, which are populated with their  own recordsource. So, one record equals to about 7 connections.

i am not a great network p[erson, I am programmer and I do close my recordset as soon as I can, but there are still live concurent connections sometimes.

As a not network person, could you guys confirm my theory above because I also read that Win Server OSs (2003, 2008, 2012?) have unlimited TCP/IP concurrent connections, and I wanted to get some thoughts on this before I venture off into getting a new server.

As well, going back to the 20 concurrent TCP/IP connections, if there any way I can check the number of live TCP/IP connections on the spot?

Thank you
0
Comment
Question by:APD_Toronto
[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
  • 2
3 Comments
 
LVL 15

Expert Comment

by:Rob Stone
ID: 39279264
You can check your current connections in Resource Monitor. Then click on the Network tab and drop down TCP/IP connections.

I think you are right on 20 concurrent connections, you can confirm here:
Go to Start > Run and type winver.
Click on Microsoft Software License Terms hyperlink and scroll down to Section 3 - Device Connections. This will tell you how many you can have connect.

You won't have an 'unlimited' amount of TCP/IP connections, but you'll have enough you won't need to worry about it.  I've read posts that 2003 people had 70,000 concurrent connections so your 20 won't worry it ;)
0
 

Author Comment

by:APD_Toronto
ID: 39279397
Under winver I did confirm that it is 20.

Under the Resource monitor I found "TCP Connections" list, but how do I get exact number? In the same place, to the right, it sais "TCP Connections" 100, but it also changes to 500, but the limit is as we confirmed 20.

I was expecting to find a number between 0 and 20, but maximum 20.
0
 
LVL 15

Accepted Solution

by:
Rob Stone earned 2000 total points
ID: 39279875
That will show all the TCP/IP connections to your client.

If you want to get more granular, you probably want to install Network Monitor 3.4 (free Microsoft download) and put a trace on. You can filter out by the conversation.

There are guides out on the web on how to use this, and YouTube vid's as well. Here is an example.
http://www.windowsecurity.com/articles-tutorials/misc_network_security/Network-Monitoring-Network-Monitor-34-Part1.html
0

Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

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…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

715 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