Tuesday, March 20, 2012

:[[DBNETLIB][ConnectionWrite (WrapperWrite())

Hi ,
I am getting below mentioned error.
[dtmdump 2812] DT-03315W: It has to be manually re-created after a restore from this backup.
[dtmdump 2812] (16 hours 7 minutes 55 seconds: 2716 objects remain. Unloading. )
[dtmdump 2812] Database server message:[[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error. Check your network documentation.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[jan2004_loans_non_ppm]': [NO PREVIOUS COMMAND] Connection failure
[dtmdump 2812] (16 hours 15 minutes 43 seconds: 2715 objects remain. Unloading. )
[dtmdump 2812] Database server message:[[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error. Check your network documentation.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[jan2004_minixref_final]': [ERROR] Connection failure
[dtmdump 2812] Database server message:[[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error. Check your network documentation.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[jmh_brg_new_loans]': [ERROR] Connection failure
[dtmdump 2812] Database server message:[[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error. Check your network documentation.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[keytables]': [ERROR] Connection failure
[dtmdump 2812] Database server message:[[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error. Check your network documentation.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[ll_disc]': [NO PREVIOUS COMMAND] Connection failure
[dtmdump 2812] Database server message:[[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error. Check your network documentation.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[llrr]': [NO PREVIOUS COMMAND] Connection failure
[dtmdump 2812] (16 hours 29 minutes 16 seconds: 2710 objects remain. Unloading. )
This error comes when i try to take a logical backup of the database thru SQLBACKTRACK
I was having this problem too. But I think I've fixed it. Now, it may come as no surprise to you (then again it might), but Microsoft has a tendency to release software with some major bugs in it. I mean, how the hell can something like this get past the
testing phase?
Oh well, that being beside the point, the fix is actually in the data access components themselves. There are many reasons this error can happen. It can be any one of the following:
1) SQL Server resides on a Windows 2003 box while clients reside on a server with anything OTHER than 2003 installed.
2) SQL Server is not configured properly (unlikely, but this *is* a possiblity)
3) Client (or server) has resource issues (not enough RAM, or even HD space)
There are more errors than that, but I'm sure you don't really care. Instead, you rather just know what to do about it. Well... All you should have to do is go to the Microsoft download site and download the Microsoft Data Access Components (MDAC) version
2.8. This version has many hotfixes and updates that should resolve this issue.
Download the MDAC 2.8 onto the client machine (NOT THE SERVER (unless the client and server are the same of course)) and install it. You will have to restart the machine once the installation is complete.
If that doesn't fix your problem, then at least you have the latest MDAC with the proper hotfixes and security updates... I found that there was actually a performance upgrade when I installed it too...
- ZE7EN Out
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
|||I had the same error: Database server
message:[[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network
error. Check your network documentation.].
It ended up being the NIC card. I changed to a 3com from using the
onboard one (maybe bad driver or something), and errors stopped.
sql

No comments:

Post a Comment