Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 218
  • Last Modified:

Dropped ODBC connections from Access to Sql Server 2008 R2


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.
1 Solution

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now