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

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
0
alevin16
Asked:
alevin16
  • 4
  • 2
1 Solution
 
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
 
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
 
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
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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