SP3a...

From: Chris Marsh (cmarsh_at_synergy-intl.com)
Date: 09/03/04


Date: Thu, 2 Sep 2004 20:22:29 -0400

Hi,

I we are using VFP & SQL2000 together. At one clients office we are getting
problems with data storing "Null" values in about a dozen different columns
in 4 different tables. I did some research and realized that when we
reinstalled the server we skipped putting SP3 in place. So, I did that last
night hoping that would resolve the problems. However, that wasn't the
case. We had the same problem today that we had yesterday. Part of the
SP3a relates to a bug fix for Q236876 and Q313352 which somewhat look like
the same problems we had been having. Please keep in mind the code works X
amount of the time it just fails occasionally.

Now, during the install of SP3a I had a problem on the MDAC piece of the
install. How do I tell if the current MDAC 2.71 is in place? And, this is
in an environment that functions between a 2003 Server and a 2000 SBS (SQL
Server). Any known issues here?

Thanks - I have a complicated puzzle here.

Chris



Relevant Pages

  • RE: SQL 2000 & Null Values...
    ... > reinstalled the server we skipped putting SP3 in place. ... during the install of SP3a I had a problem on the MDAC piece of the ... How do I tell if the current MDAC 2.71 is in place? ... is there any suggested code that we should put into place that will ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Updates KB924667, 927779, 923723
    ... Server W2K SP4 was running MDAC 2.80. ... The other server is running MDAC 2.53 SP3. ... attempting to install Security Update for Microsoft Data Access Components ... Thinking about upgrading to newer version of MDAC ...
    (microsoft.public.windowsupdate)
  • Re: Errors after upgrade
    ... I tried the MDAC 2.8 install, ... >This is a known issue with some installations of Windows ... >Mark Allison, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: TADOConnection error - connection string
    ... If I installed the MAC myself, what would happen if reinstall SQL Server ... Will that replaced by SQL Server 2000's MDAC? ... However I would first suggest you install the latest version of MDAC like ...
    (borland.public.delphi.database.ado)
  • Re: anyone knows what happen?
    ... I have installed SP3a for my SQL server 2000 ... since my server is attacks others server's 1433 port ... so, I thought my server was infected by slammer, so I install the SP3a ...
    (microsoft.public.sqlserver.security)