Error:0 cannot load the DLL xpstar.dll

Have recently started getting this error in Sql2000 on W2KAdvanceServer.
Wasn't getting the error until about 2 weeks ago. Have not added any
software, drivers etc. Have verified the xpstar.dll is in the correct
directory and is accessible. Have uninstalled and reinstalled Sql 2000 and
the appropriate service packs twice and that has not helped. Have plenty hd
space and ram. Seems to be no Microsoft paper or troubleshooting on this
error -but there are several people who have experienced it and report it on
other sql user groups (however no resolutions). Any idea?
Thanks
Victoria
Does installing/re-installing MDAC 2.8 help?
"MSSQL" <colemanv@.stripes.osd.mil> wrote in message
news:uP$AkiynEHA.596@.TK2MSFTNGP11.phx.gbl...
> Have recently started getting this error in Sql2000 on W2KAdvanceServer.
> Wasn't getting the error until about 2 weeks ago. Have not added any
> software, drivers etc. Have verified the xpstar.dll is in the correct
> directory and is accessible. Have uninstalled and reinstalled Sql 2000
> and
> the appropriate service packs twice and that has not helped. Have plenty
> hd
> space and ram. Seems to be no Microsoft paper or troubleshooting on this
> error -but there are several people who have experienced it and report it
> on
> other sql user groups (however no resolutions). Any idea?
> Thanks
> Victoria
>
|||Is MDAC 2.8 part of the SP3 service pack? or part of SP2? Sorry to be
ignorant on this but I did see MDAC being updated when I installed SP3.
How would I get it back to MDAC 2.8 without reinstalling? Once again -
I aplogize for asking what is most likely a stupid question.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||You can go to Microsoft.com and in the upper right search Microsoft.com for
MDAC. Second result should be MDAC 2.8 download. I have no idea if this
will solve the problem, but I do know it corrects a lot of problems I've had
with SQL Server.
This link will go directly to the MDAC download page also:
http://www.microsoft.com/downloads/d...DisplayLang=en
"Victoria Coleman" <colemanv@.stripes.osd.mil> wrote in message
news:%23pV5IDznEHA.3396@.tk2msftngp13.phx.gbl...
> Is MDAC 2.8 part of the SP3 service pack? or part of SP2? Sorry to be
> ignorant on this but I did see MDAC being updated when I installed SP3.
> How would I get it back to MDAC 2.8 without reinstalling? Once again -
> I aplogize for asking what is most likely a stupid question.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||I am loading MDAC 2.8 now and will see if that fixes the problem.
Thanks for responding so quickly. I really appreciate it.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!