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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: SqlJunkies User (User_at_-NOSPAM-SqlJunkies.com)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 09:25:41 -0700

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.

Relevant Pages

  • Re: Hotfix Post SP4
    ... Build 2148, to fix the SQLDiag issue, but also fixes another 10 or so. ... to fix the Query Analyzer DTC issue. ... SQL Server Version Database ... You receive an error message if you use the sp_addalias or sp_dropalias ...
    (microsoft.public.sqlserver.clustering)
  • Re: Inconsistent negative numerical values in SQL2K database table
    ... Earl Newcomer wrote: ... >fix of 1*value and it works as you mentioned. ... As far as I can tell, so long as SQL Server has to do an arithmetic ... Since the cube is partitioned some of the partitions are ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2000 SP4 - realease date
    ... it looks like SP4 is targeted for the first half ... there is no "fix" with UMS non-yielding processes ... New concurrency and scheduling diagnostics added to SQL Server: ... FIX: You are prompted for password confirmation after you change a standard ...
    (microsoft.public.sqlserver.server)
  • Re: Inconsistent negative numerical values in SQL2K database table
    ... fix of 1*value and it works as you mentioned. ... To answer your question about copying between SQL Server instances I don't ... will copy between SQL Server tables carrying with it the incorrect sign bit. ... Since the cube is partitioned some of the partitions are ...
    (microsoft.public.sqlserver.server)
  • Re: Treatment of extension column changed in SP4?
    ... 323039 FIX: Full-Text Search Population of a Word Document Stored ... in SQL Server Causes CPU Spin with SQL Server 2000 Service Pack 2 ... may declare it a bug as it breaks your custom IFilter post-SP3 and then the ... Unknown Extensions ...
    (microsoft.public.sqlserver.fulltext)