04-11-05 10:57 PM
Now I also notice when I go to ODBC Administrator i get an error too. "the
ODBC resource DLL (C:\windows\system32\odbcint.dll) is a different version
than the administrator (c:\windows\system32\odbcad32.exe). You need to
reinstall the ODBC components to ensure proper operation.
All I can say DO NOT INSTALL SP1.
What ever this service pack did, it's not worth it.
Can anyone help?
"André" wrote:
> HI,
>
> I only have SQL 2000 with sp 3a and the OS on this. This is a production
> server.
>
> When I discovered this error, I went to our development server (at that ti
me
> did not have sp1 installed) and check to see if the right click on the tab
le
> and open all records/query to see if it worked, it did. right after that,
i
> installed sp1 and rebooted, then check to see if it still worked, and it d
id
> not.
>
> I installed mdac 2.8 to see if that would fix the issue, then I tried to
> register those dll's and I could not register them. I then uninstalled th
e
> sp, and then it worked again.
>
> I did this at one time, so I now it’s the sp that is doing this. I have
not
> uninstall the sp on the production server yet.
>
> I did notice one other thing, not sure if or how it is related, before I
> found out that the query tools do not work in sql server, I when to the
> computer management via right click on my computer, then manage and I get
a
> snap in error: snap-in failed to initialize name: event viewer extension
> CLSID:{394c052e-b830-11d0-9a86-00c04fd8dbf7}
>
> This is a pretty new server, less then one month. Everything was working
> great and the only thing that changed was the service pack. I should try
to
> install the sp1 again on the development server to see if I get the same s
nap
> in error…. Monday I guess
>
> Please help with this issue
>
> Andre
>
[ Post a follow-up to this message ]
| 
"André" wrote:
> Hi,
>
> I just installed Win 2003 SP 1 and now I get this error on my sql server
>
> the query cannot be executed because some files are either missing or not
> registered
>
> I’ve tried [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;315868[/url
]
> but I can not register the dlls
>
> I’ve reinstalled mdac 2.8
> I dl component checker tool and it’s unknown
>
>
>
> How can I fix this?
>
