ODBC -- Call Failed

Posted on 2012-08-10
Last Modified: 2012-08-15
Hello Experts,

I have a frontend in Access 2010 and Backend in SQL 2008 Express R2. Even though Access is 2010 the rest of Office is 2007.

Sometimes I get a series of ODBC errors, like Call Failed or Update Failed.

The computer where SQL is installed on is Windows 7 Pro and I have read that in Win 7 there are limited numbers of TCP/IP connections. Is this true, and can this be causing the ODBC errors?

If this is the case, I guess I have no choice than to upgrade the "server" to actual server, like Windows 2008, but before I do is there a way to look at how many  TCP/IP connections are actually open? Also what is the TCP/IP limitations of Win 7?

I assume that Win 2008 does not have such limits, correct?

Question by:APD_Toronto
    LVL 77

    Expert Comment

    by:David Johnson, CD, MVP
    20 connection limit in Windows Client Operating Systems.
    Server depends upon version. Web and Foundation editions have connection limits (50) while Standard, Enterprise, and Data center do not.

    Author Comment

    Is there a way to check the number of connections at any given time?
    LVL 38

    Accepted Solution

    Grab a copy of the Sysinternals TCPView v3.05 from MS.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
    The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
    The viewer will learn how to back up in Windows 7 with native tools. This should be the first step. Third party tools should also be used. Access the Backup and Restore options: Click on the windows 7 start ball in the lower left corner of the scree…
    The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

    779 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

    17 Experts available now in Live!

    Get 1:1 Help Now