DBNETLIB connection error on Azure with SQL

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
alevin16Asked:
Who is Participating?
 
John Gates, CISSPSecurity ProfessionalCommented:
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
 
John Gates, CISSPSecurity ProfessionalCommented:
Since no one has given you an answer, let's start here:

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

-D-
0
 
alevin16Author Commented:
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
John Gates, CISSPSecurity ProfessionalCommented:
You are welcome.  Please let me know how you do.
0
 
alevin16Author Commented:
That took care of it.  It looked like the log was just getting too big.  Sorry for the delay in filling this out
0
 
John Gates, CISSPSecurity ProfessionalCommented:
Glad you got it sorted!

Happy Computing :-)

-D-
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.