Solved

DBNETLIB connection error on Azure with SQL

Posted on 2014-12-23
6
117 Views
Last Modified: 2015-01-21
Hello All

I have a database where the backend is on an Azure server in SQL and the front end is in Access 2010 on the users computers (the whole program started life as an Access 2010 database housed locally)

Some users are randomly getting a DBNETLIB connectionwrite error (I have attached a screenshot).  I have tried changing a registry setting but it did not work.

Any help is really appreciated!
Thanks!error msg from connection error
0
Comment
Question by:alevin16
  • 4
  • 2
6 Comments
 
LVL 17

Expert Comment

by:John Gates
ID: 40529060
Since no one has given you an answer, let's start here:

http://support.microsoft.com/kb/942861/en-us

-D-
0
 
LVL 17

Accepted Solution

by:
John Gates earned 500 total points
ID: 40529062
Also your SQL server transaction log may be filling up.  What Recovery model do you have set for the database? Full? Simple?


Thanks!
-D-
0
 

Author Comment

by:alevin16
ID: 40531971
Hi dimante,

I did not think about the transaction log filling.  I am new to the sql server thing (someone else handles it at the company).  I am going to ask them to see if they can give me any more insight.

Thank yoU!
Andy
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 17

Expert Comment

by:John Gates
ID: 40532544
You are welcome.  Please let me know how you do.
0
 

Author Closing Comment

by:alevin16
ID: 40562315
That took care of it.  It looked like the log was just getting too big.  Sorry for the delay in filling this out
0
 
LVL 17

Expert Comment

by:John Gates
ID: 40562453
Glad you got it sorted!

Happy Computing :-)

-D-
0

Featured Post

New! My Passport Wireless Pro Wi-Fi Mobile Storage

Portable wireless storage to offload, edit, and stream anywhere.

High-capacity, wireless mobile storage designed to accompany professional photographers and videographers in the field to easily offload, edit and stream captured photos and high-definition videos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Viewers will learn how the fundamental information of how to create a table.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

932 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

18 Experts available now in Live!

Get 1:1 Help Now