Results 1 to 3 of 3
  1. #1
    Historypaul is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Nov 2012
    Posts
    64

    Connection to SQL Server ODBC Failed

    I connected all of my linked tables to SQL Azure. When I open up my Access front end, everything works fine 100% of the time. After 5 minutes, I get this error message:
    Click image for larger version. 

Name:	Screenshot_6.jpg 
Views:	22 
Size:	22.6 KB 
ID:	19024

    ODBC-call failed.

    [Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host. (10054) [Microsoft][SQL Server Native Client 11.0]Communication link failure (#10054)

    If I close and reopen Access, everything is connected and works just fine...

  2. #2
    Historypaul is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Nov 2012
    Posts
    64
    I tried everything I could, then finally talked to SQL Azure tech support, who referred me to a known issue http://support.microsoft.com/kb/2730109.

    The known issues circumstances don't seem to apply to me, so I'm reluctant to accept it, and their "workaround" doesn't seem feasible to me, so I'm likely going to be trying other SQL hosting providers...

  3. #3
    Historypaul is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Nov 2012
    Posts
    64
    Just an update... (hopefully someone can learn from my "testing"). I ended up going to the Amazon SQL service to test it out as a backend. Works great, and I don't have any of the time-out problems that I had with SQL Azure.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 03-02-2015, 09:44 AM
  2. Replies: 2
    Last Post: 01-21-2014, 11:23 AM
  3. Replies: 1
    Last Post: 05-17-2012, 05:51 PM
  4. Odbc connection to 'datasourcename' failed
    By nmcentire in forum Import/Export Data
    Replies: 1
    Last Post: 11-24-2010, 07:28 PM
  5. Replies: 2
    Last Post: 11-10-2009, 02:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums