Dropped ODBC connections from Access to Sql Server 2008 R2

Posted on 2012-09-18
Last Modified: 2013-03-06

I am a newbie in Sql Server 2008 R2 Administration. Recently we migrated an Access database to Sql Server 2008 R2 DB. These users connect to Sql Server 2008 R2 database through Access using ODBC connections. Today I received few complaints that these users were being disconnected in the middle of their Access ODBC sessions while working on the SQL Server Database.

Can you please let me know what could be doing this? I do not have details of the error hence I am unable to provide them. But before anything, I just want to know is there a way in Sql Server to capture the Connection errors, users are facing or it can only be captured in Access?

We have a meeting tomorrow morning and I have to at least let them know if anything can be done from Sql Server end.
Question by:farooqhussain
    1 Comment
    LVL 39

    Accepted Solution


    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    732 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

    24 Experts available now in Live!

    Get 1:1 Help Now