error: CoCreate of DSO for BULKIMPORTSTREAM

Hi,
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experiencing this problem. My problem is when using
bulk insert every once in awhile we'll receive a
CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
error. Restarting the service used to take care of this for awhile, but now
this happens everyday.
Is there any special hotfixes for this or a final fix for this? Or any
other information on it. My next steps are to re-apply sp3a (sp4 hasn't
made it through testing yet), if that fails register the IMPPROV.dll ...
other than that... i'm out of ideas.
Please Please help!!!!
thanks in advance.Hi
This may be a ERR_DLL_INIT_FAILED error, in which case you may want to try
re-installing/updating MDAC, check system resources...
I am not sure if this is relevant! http://www.aspfaq.com/show.asp?id=2388
John
"Chris Trailer" wrote:

> Hi,
> Sql 2000 SP3a, Windows 2000 Enterprise, SP4
> I've extensively searched through most means (google, microsoft,
> newsgroups,etc) and really haven't found a definitive answer. There reall
y
> isn't any real answers. I run an ASP and most clients on one of the
> production servers are experiencing this problem. My problem is when usin
g
> bulk insert every once in awhile we'll receive a
> CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a
> error. Restarting the service used to take care of this for awhile, but n
ow
> this happens everyday.
> Is there any special hotfixes for this or a final fix for this? Or any
> other information on it. My next steps are to re-apply sp3a (sp4 hasn't
> made it through testing yet), if that fails register the IMPPROV.dll ...
> other than that... i'm out of ideas.
> Please Please help!!!!
> thanks in advance.
>
>