Solved

DBNETLIB connection error on Azure with SQL

Posted on 2014-12-23
6
123 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 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
Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

 
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

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…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Viewers will learn how the fundamental information of how to create a table.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

628 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