Error: Unable to Load SQL OLEDB provider resource dll. The application cannot continue.

I am getting this error while developing ASP code for an app. It seems to
be doing this if I try to insert a record that is already in the DB. I am
using IE 6 and it just hangs when this happens, I have to close and reopen
the browser to work any longer. The problem is that this error message is
only displayed on the server and the server is unattended (except every now
and again). Then when the admin logs on to the server, there are a bunch of
these errors which they have to click through.

Why is it popping this error on the server instead of an actual SQL error on
the browser?

This server is Windows 2000 Server, SQL 2000, all service packs, new MDAC.
But they just upgraded the PDC (primary domain controller) from NT to 2000,
that seems to be when the problems started. Could that upgrade have done
anything to the SQL Server?

Thanks,
Drew Laing

Re: Error: Unable to Load SQL OLEDB provider resource dll. The application cannot continue.

Drew wrote:
> I am getting this error while developing ASP code for an app. It
> seems to be doing this if I try to insert a record that is already in
> the DB. I am using IE 6 and it just hangs when this happens, I have
> to close and reopen the browser to work any longer. The problem is
> that this error message is only displayed on the server and the
> server is unattended (except every now and again). Then when the
> admin logs on to the server, there are a bunch of these errors which
> they have to click through.
>
> Why is it popping this error on the server instead of an actual SQL
> error on the browser?
>
> This server is Windows 2000 Server, SQL 2000, all service packs, new
> MDAC. But they just upgraded the PDC (primary domain controller) from
> NT to 2000, that seems to be when the problems started. Could that
> upgrade have done anything to the SQL Server?
>

If the results of this Google search do not help:
http://groups.google.com/groups?hl=en&lr=&c2coff=1&q=Unable+ to+Load+SQL+OLEDB+provider+resource+dll.%22&btnG=Search

Could you show the code that generates this error?

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.