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!

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
VictoriaDoes 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
>

ERROR: table don't support this operation

hello all,

this query causes error on some servers (sql2000 sp3). on our development server is this ok. we have restore the database from customer server to the development server, this is ok too. we don't know which configuration on the server can change to solve the problem.
-
select distinct V.Vereinsname as Vereinsname, V.VNr as VerNr, V.PLZ as PLZ, V.Ort as Ort, V.Strasse1 as Stra?e1, V.Strasse2 as Stra?e2, '0' as Sel
, V.Statusfeld01, V.Statusfeld02, V.Statusfeld03, V.Statusfeld04, V.Statusfeld05, V.Statusfeld06, V.Statusfeld07, V.Statusfeld08, V.Statusfeld09
, V.Statusfeld10, V.Statusfeld11, V.Statusfeld12, V.Statusfeld13, V.Statusfeld14, V.Statusfeld15, V.Statusfeld16

from VRMWSTD V
where 0 < V.VKrNr
and V.VKrNr in (1)
order by Vereinsname

-
the message in german is: "Tabelle unterstützt diese Operation nicht."

many thanks in advance

duong

Have you checked the index?|||just a question but why do you do this -
where 0 < V.VKrNr
and V.VKrNr in (1)

and not simply

where V.VKrNr = 1

I don't know. . . sql might optimize it out, but seems like overkill.|||Could you please post a simple repro script? The error message looks like a client library message and not SQL Server. It could be that you are trying to add/update rows in the datatable or recordset for example and it is not supported. This can be due to the nature of the SELECT statement (use of DISTINCT and ORDER BY clauses) which will make the resultset read-only.