Enterprise Manager error

After installing Enterprise Manager on a new HP laptop running XP Pro sp2, I get the following error message when to trying to "Return all rows" from a table. "Provider cannot be found. It may not be properly installed."

Everything I read on the internet says to install or reinstall Jet 4.0 sp8, but this has not solved the problem. I've also installed the latest MDAC...MDAC 2.8 SP1 on Windows XP SP2, and ran the compchecker, everthing checks out ok. Any ideas?

Thanks
T.C.

I have a new Sony VAIO laptop and am running XP Pro sp2 and get the same error when trying to open a table in any database.
I just installed SQL2000 sp4 hoping the error would go away...it didn't.
Did your problem ever get resolved?
|||

Hello,

I had searched through Google and Microsoft website for the error message. I find a few matches. You could try the solution suggested in http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=44561. Another link with suggestion from alleged Microsoft online support is http://www.mcse.ms/message201860.html. It could be due to MDAC issue.

Enterprise Manager error

After installing Enterprise Manager on a new HP laptop running XP Pro sp2, I get the following error message when to trying to "Return all rows" from a table. "Provider cannot be found. It may not be properly installed."

Everything I read on the internet says to install or reinstall Jet 4.0 sp8, but this has not solved the problem. I've also installed the latest MDAC...MDAC 2.8 SP1 on Windows XP SP2, and ran the compchecker, everthing checks out ok. Any ideas?

Thanks
T.C.

I have a new Sony VAIO laptop and am running XP Pro sp2 and get the same error when trying to open a table in any database.
I just installed SQL2000 sp4 hoping the error would go away...it didn't.
Did your problem ever get resolved?
|||

Hello,

I had searched through Google and Microsoft website for the error message. I find a few matches. You could try the solution suggested in http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=44561. Another link with suggestion from alleged Microsoft online support is http://www.mcse.ms/message201860.html. It could be due to MDAC issue.

Enterprise Manager error

After installing Enterprise Manager on a new HP laptop running XP Pro sp2, I get the following error message when to trying to "Return all rows" from a table. "Provider cannot be found. It may not be properly installed."

Everything I read on the internet says to install or reinstall Jet 4.0 sp8, but this has not solved the problem. I've also installed the latest MDAC...MDAC 2.8 SP1 on Windows XP SP2, and ran the compchecker, everthing checks out ok. Any ideas?

Thanks
T.C.

I have a new Sony VAIO laptop and am running XP Pro sp2 and get the same error when trying to open a table in any database.

I just installed SQL2000 sp4 hoping the error would go away...it didn't.

Did your problem ever get resolved?|||

Hello,

I had searched through Google and Microsoft website for the error message. I find a few matches. You could try the solution suggested in http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=44561. Another link with suggestion from alleged Microsoft online support is http://www.mcse.ms/message201860.html. It could be due to MDAC issue.

enterprise manager doesn't load

me bad - i installed visual studio (with sql express) then put the patches on
and sp2 for sql express.. then loaded the development version -- now
enterprise manager for sql 2005 won't load --
how do i make it - it doesn't give an error - just isn't there.
Do you mean Management Studio?
"Sandy Ryan" <SandyRyan@.discussions.microsoft.com> wrote in message
news:0E4A4E64-3F11-44AF-A302-0041D7E59135@.microsoft.com...
> me bad - i installed visual studio (with sql express) then put the patches
> on
> and sp2 for sql express.. then loaded the development version -- now
> enterprise manager for sql 2005 won't load --
> how do i make it - it doesn't give an error - just isn't there.
|||yes - it turns out that you have to have IIS installed to allow the
management studio to work - seems stupid to me - but it is what it is.
"Aaron Bertrand [SQL Server MVP]" wrote:

> Do you mean Management Studio?
>
> "Sandy Ryan" <SandyRyan@.discussions.microsoft.com> wrote in message
> news:0E4A4E64-3F11-44AF-A302-0041D7E59135@.microsoft.com...
>
>
|||> yes - it turns out that you have to have IIS installed to allow the
> management studio to work - seems stupid to me - but it is what it is.
Well, that's not true because I use Management Studio on several systems
without IIS configured. But maybe you tripped something else when you
installed IIS. <shrug>
|||You don't need to have IIS installed to run SQL Server 05 or any of it's
tools.
Your issue may be caused by conflicts with .NET framework 2.0. Try
uninstalling the 2.0 framework and then reinstalling the latest copies from
Microsoft.
Search MS knowledge base and you'll find that many users have had problems
with sql server 05 and .NET 2.0
Sincerely,
John K
Knowledgy Consulting, LLC
www.knowledgy.org
Atlanta's Business Intelligence and Knowledge Management Experts
"Sandy Ryan" <SandyRyan@.discussions.microsoft.com> wrote in message
news:0E4A4E64-3F11-44AF-A302-0041D7E59135@.microsoft.com...
> me bad - i installed visual studio (with sql express) then put the patches
> on
> and sp2 for sql express.. then loaded the development version -- now
> enterprise manager for sql 2005 won't load --
> how do i make it - it doesn't give an error - just isn't there.

Enterprise Manager blocks network on XP

I'm running XP SP2 (and all the latest hotfixes) and administer a
bunch of SQL2000 servers. Whenever I have enterprise manager running,
I find that my network access seems to block regularly. What I mean by
that is, If I open Explorer and try to access network drives, explorer
will hang for 10-15 second before responding. The same thing occurs
for other apps that access network drives (open/save dialogs, apps
with directory tree windows, etc).
Is anyone else seeing this same behavior? Any idea how to trace
something like this? It isn't network related according to a sniffer -
it seems more similar to they type of blocking we used to see with old
ODBC-based applications.
Thanks
What happens if you turn off the server state polling in
Enterprise Manager? On the menu go to tools then select
options. Clear the checkbox for Server State Polling on the
General tab.
You'd also want to check the event logs if turning off the
polling makes no difference.
-Sue
On 27 Feb 2007 12:28:53 -0800, steven.cardinal@.gmail.com
wrote:

>I'm running XP SP2 (and all the latest hotfixes) and administer a
>bunch of SQL2000 servers. Whenever I have enterprise manager running,
>I find that my network access seems to block regularly. What I mean by
>that is, If I open Explorer and try to access network drives, explorer
>will hang for 10-15 second before responding. The same thing occurs
>for other apps that access network drives (open/save dialogs, apps
>with directory tree windows, etc).
>Is anyone else seeing this same behavior? Any idea how to trace
>something like this? It isn't network related according to a sniffer -
>it seems more similar to they type of blocking we used to see with old
>ODBC-based applications.
>Thanks
|||I am hesitantly optimistic. Since turning that off, things seem
better. I was aware of the option in each server registration about
showing the server state (which, if turned off prompts me everytime I
want to connect) but wasn't aware of the global polling option.
Thank you very, very, very, very much
Steve
On Feb 27, 11:32 pm, Sue Hoegemeier <S...@.nomail.please> wrote:[vbcol=seagreen]
> What happens if you turn off the server state polling in
> Enterprise Manager? On the menu go to tools then select
> options. Clear the checkbox for Server State Polling on the
> General tab.
> You'd also want to check the event logs if turning off the
> polling makes no difference.
> -Sue
> On 27 Feb 2007 12:28:53 -0800, steven.cardi...@.gmail.com
> wrote:
>

Enterprise Manager blocks network on XP

I'm running XP SP2 (and all the latest hotfixes) and administer a
bunch of SQL2000 servers. Whenever I have enterprise manager running,
I find that my network access seems to block regularly. What I mean by
that is, If I open Explorer and try to access network drives, explorer
will hang for 10-15 second before responding. The same thing occurs
for other apps that access network drives (open/save dialogs, apps
with directory tree windows, etc).
Is anyone else seeing this same behavior? Any idea how to trace
something like this? It isn't network related according to a sniffer -
it seems more similar to they type of blocking we used to see with old
ODBC-based applications.
ThanksWhat happens if you turn off the server state polling in
Enterprise Manager? On the menu go to tools then select
options. Clear the checkbox for Server State Polling on the
General tab.
You'd also want to check the event logs if turning off the
polling makes no difference.
-Sue
On 27 Feb 2007 12:28:53 -0800, steven.cardinal@.gmail.com
wrote:

>I'm running XP SP2 (and all the latest hotfixes) and administer a
>bunch of SQL2000 servers. Whenever I have enterprise manager running,
>I find that my network access seems to block regularly. What I mean by
>that is, If I open Explorer and try to access network drives, explorer
>will hang for 10-15 second before responding. The same thing occurs
>for other apps that access network drives (open/save dialogs, apps
>with directory tree windows, etc).
>Is anyone else seeing this same behavior? Any idea how to trace
>something like this? It isn't network related according to a sniffer -
>it seems more similar to they type of blocking we used to see with old
>ODBC-based applications.
>Thanks|||I am hesitantly optimistic. Since turning that off, things seem
better. I was aware of the option in each server registration about
showing the server state (which, if turned off prompts me everytime I
want to connect) but wasn't aware of the global polling option.
Thank you very, very, very, very much
Steve
On Feb 27, 11:32 pm, Sue Hoegemeier <S...@.nomail.please> wrote:[vbcol=seagreen]
> What happens if you turn off the server state polling in
> Enterprise Manager? On the menu go to tools then select
> options. Clear the checkbox for Server State Polling on the
> General tab.
> You'd also want to check the event logs if turning off the
> polling makes no difference.
> -Sue
> On 27 Feb 2007 12:28:53 -0800, steven.cardi...@.gmail.com
> wrote:
>
>
>

Enterprise Manager blocks network on XP

I'm running XP SP2 (and all the latest hotfixes) and administer a
bunch of SQL2000 servers. Whenever I have enterprise manager running,
I find that my network access seems to block regularly. What I mean by
that is, If I open Explorer and try to access network drives, explorer
will hang for 10-15 second before responding. The same thing occurs
for other apps that access network drives (open/save dialogs, apps
with directory tree windows, etc).
Is anyone else seeing this same behavior? Any idea how to trace
something like this? It isn't network related according to a sniffer -
it seems more similar to they type of blocking we used to see with old
ODBC-based applications.
ThanksWhat happens if you turn off the server state polling in
Enterprise Manager? On the menu go to tools then select
options. Clear the checkbox for Server State Polling on the
General tab.
You'd also want to check the event logs if turning off the
polling makes no difference.
-Sue
On 27 Feb 2007 12:28:53 -0800, steven.cardinal@.gmail.com
wrote:
>I'm running XP SP2 (and all the latest hotfixes) and administer a
>bunch of SQL2000 servers. Whenever I have enterprise manager running,
>I find that my network access seems to block regularly. What I mean by
>that is, If I open Explorer and try to access network drives, explorer
>will hang for 10-15 second before responding. The same thing occurs
>for other apps that access network drives (open/save dialogs, apps
>with directory tree windows, etc).
>Is anyone else seeing this same behavior? Any idea how to trace
>something like this? It isn't network related according to a sniffer -
>it seems more similar to they type of blocking we used to see with old
>ODBC-based applications.
>Thanks|||I am hesitantly optimistic. Since turning that off, things seem
better. I was aware of the option in each server registration about
showing the server state (which, if turned off prompts me everytime I
want to connect) but wasn't aware of the global polling option.
Thank you very, very, very, very much
Steve
On Feb 27, 11:32 pm, Sue Hoegemeier <S...@.nomail.please> wrote:
> What happens if you turn off the server state polling in
> Enterprise Manager? On the menu go to tools then select
> options. Clear the checkbox for Server State Polling on the
> General tab.
> You'd also want to check the event logs if turning off the
> polling makes no difference.
> -Sue
> On 27 Feb 2007 12:28:53 -0800, steven.cardi...@.gmail.com
> wrote:
> >I'm running XP SP2 (and all the latest hotfixes) and administer a
> >bunch of SQL2000 servers. Whenever I have enterprise manager running,
> >I find that my network access seems to block regularly. What I mean by
> >that is, If I open Explorer and try to access network drives, explorer
> >will hang for 10-15 second before responding. The same thing occurs
> >for other apps that access network drives (open/save dialogs, apps
> >with directory tree windows, etc).
> >Is anyone else seeing this same behavior? Any idea how to trace
> >something like this? It isn't network related according to a sniffer -
> >it seems more similar to they type of blocking we used to see with old
> >ODBC-based applications.
> >Thanks