"Allen Bruce Anderson" <albruan@hotmail.com> wrote in message
news:e#nX34M#DHA.548@TK2MSFTNGP11.phx.gbl...
> Sorry for the cross-posting, but I'm not really sure in which newsgroup
this
> should be posted. Anyway...
>
> I have SQL Server 2000 with SP3 installed on my computer. I'm able to use
> Query Analyzer to open tables on the various databases running under SQL
> Server, but whenever I try to do so with Enterprise Manager I encounter a
> "Provider cannot be found. It may not be properly installed." error
message.
> If I try to use Server Explorer in Visual Studio .NET to open an existing
> Data Connection, I get a similar error message that reads "Unable to
connect
> to database. Provider cannot be found. It may not be properly
installed."
>
> I tried uninstalling and reinstalling SQL Server and the client tools, but
> that hasn't worked. What can I do to get the connection working again?
> Thanks for any help!
>
> Allen Anderson
>
>

"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:OHFc3lN%23DHA.1936@TK2MSFTNGP12.phx.gbl...
> Try upgrading MDAC to 2.8. See
> http://msdn.microsoft.com/downloads/list/dataaccess.asp
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
>
>
> "Allen Bruce Anderson" <albruan@hotmail.com> wrote in message
> news:e#nX34M#DHA.548@TK2MSFTNGP11.phx.gbl...
> > Sorry for the cross-posting, but I'm not really sure in which newsgroup
> this
> > should be posted. Anyway...
> >
> > I have SQL Server 2000 with SP3 installed on my computer. I'm able to
use
> > Query Analyzer to open tables on the various databases running under SQL
> > Server, but whenever I try to do so with Enterprise Manager I encounter
a
> > "Provider cannot be found. It may not be properly installed." error
> message.
> > If I try to use Server Explorer in Visual Studio .NET to open an
existing
> > Data Connection, I get a similar error message that reads "Unable to
> connect
> > to database. Provider cannot be found. It may not be properly
> installed."
> >
> > I tried uninstalling and reinstalling SQL Server and the client tools,
but
> > that hasn't worked. What can I do to get the connection working again?
> > Thanks for any help!
> >
> > Allen Anderson
> >
> >
>
>