Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

DBNETLIB connection error on Azure with SQL

Posted on 2014-12-23
6
Medium Priority
?
125 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 18

Expert Comment

by:John Gates, CISSP
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 18

Accepted Solution

by:
John Gates, CISSP earned 2000 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 18

Expert Comment

by:John Gates, CISSP
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 18

Expert Comment

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

Happy Computing :-)

-D-
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

916 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