Enterprise mangler

Hi all,
I have two workstations with fresh reloaded sql2000 client
software and fresh reloaded MDAC(current version).
When I go thru SQLEM to the database and drill down to
query the individual tables, I get a the table trying to
open and the the "Provider not found. It may not be
installed correctl" error. The provider is installed
correctly.
The only way I have found to fix this issue is to reload
Window Operating system on the workstation and then there
is no more problem. Needless to say, this is unacceptable.
Does anyone know of a fix for this? MS Support has sofar
been unable to address. Any info could help.
TIA!
Did you uninstall and reinstall the client tools? Did you apply SP3a?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Chip" <cjsmith@.teampdc.com> wrote in message
news:10c401c4384e$421a9760$3501280a@.phx.gbl...
> Hi all,
> I have two workstations with fresh reloaded sql2000 client
> software and fresh reloaded MDAC(current version).
> When I go thru SQLEM to the database and drill down to
> query the individual tables, I get a the table trying to
> open and the the "Provider not found. It may not be
> installed correctl" error. The provider is installed
> correctly.
> The only way I have found to fix this issue is to reload
> Window Operating system on the workstation and then there
> is no more problem. Needless to say, this is unacceptable.
> Does anyone know of a fix for this? MS Support has sofar
> been unable to address. Any info could help.
> TIA!
|||
> I have two workstations with fresh reloaded sql2000(sp3a) client
> software and fresh reloaded MDAC(current version 2.8)
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Yes and Yes.
> I have two workstations(WIN2K SP4) with fresh re-loaded, re-installed,
re-booted sql2000(sp3a) client
> software and fresh re-loaded, re-installed, re-booted MDAC 2.8(current
version).
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
sql

Enterprise mangler

Hi all,
I have two workstations with fresh reloaded sql2000 client
software and fresh reloaded MDAC(current version).
When I go thru SQLEM to the database and drill down to
query the individual tables, I get a the table trying to
open and the the "Provider not found. It may not be
installed correctl" error. The provider is installed
correctly.
The only way I have found to fix this issue is to reload
Window Operating system on the workstation and then there
is no more problem. Needless to say, this is unacceptable.
Does anyone know of a fix for this? MS Support has sofar
been unable to address. Any info could help.
TIA!Did you uninstall and reinstall the client tools? Did you apply SP3a?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Chip" <cjsmith@.teampdc.com> wrote in message
news:10c401c4384e$421a9760$3501280a@.phx.gbl...
> Hi all,
> I have two workstations with fresh reloaded sql2000 client
> software and fresh reloaded MDAC(current version).
> When I go thru SQLEM to the database and drill down to
> query the individual tables, I get a the table trying to
> open and the the "Provider not found. It may not be
> installed correctl" error. The provider is installed
> correctly.
> The only way I have found to fix this issue is to reload
> Window Operating system on the workstation and then there
> is no more problem. Needless to say, this is unacceptable.
> Does anyone know of a fix for this? MS Support has sofar
> been unable to address. Any info could help.
> TIA!|||
> I have two workstations with fresh reloaded sql2000(sp3a) client
> software and fresh reloaded MDAC(current version 2.8)
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Yes and Yes.
> I have two workstations(WIN2K SP4) with fresh re-loaded, re-installed,
re-booted sql2000(sp3a) client
> software and fresh re-loaded, re-installed, re-booted MDAC 2.8(current
version).
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Enterprise mangler

Hi all,
I have two workstations with fresh reloaded sql2000 client
software and fresh reloaded MDAC(current version).
When I go thru SQLEM to the database and drill down to
query the individual tables, I get a the table trying to
open and the the "Provider not found. It may not be
installed correctl" error. The provider is installed
correctly.
The only way I have found to fix this issue is to reload
Window Operating system on the workstation and then there
is no more problem. Needless to say, this is unacceptable.
Does anyone know of a fix for this? MS Support has sofar
been unable to address. Any info could help.
TIA!Did you uninstall and reinstall the client tools? Did you apply SP3a?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Chip" <cjsmith@.teampdc.com> wrote in message
news:10c401c4384e$421a9760$3501280a@.phx.gbl...
> Hi all,
> I have two workstations with fresh reloaded sql2000 client
> software and fresh reloaded MDAC(current version).
> When I go thru SQLEM to the database and drill down to
> query the individual tables, I get a the table trying to
> open and the the "Provider not found. It may not be
> installed correctl" error. The provider is installed
> correctly.
> The only way I have found to fix this issue is to reload
> Window Operating system on the workstation and then there
> is no more problem. Needless to say, this is unacceptable.
> Does anyone know of a fix for this? MS Support has sofar
> been unable to address. Any info could help.
> TIA!

Enterprise Manager causing extensive network traffic

Does anybody have any idea what is happening here. On 3 out of five workstations when entering Enterprise Manager the network traffic jumps drastically to the point that the server needs to be rebooted. Any information would be greatly appreciated.
Thanks
NewbieTry Using the SQL Profiler that comes with SQL Server

This underused programme will list every command that hits the SQL Server in Real time.

Just run the default trace & see whats happening when a client logs on

GW|||I used profiler this morning, using the default trace and I also set it to log everything. It didn't log anything out of the ordinary, and there was nothing that coincided with the amount of traffic being generated.

Originally posted by GWilliy
Try Using the SQL Profiler that comes with SQL Server

This underused programme will list every command that hits the SQL Server in Real time.

Just run the default trace & see whats happening when a client logs on

GW|||OK

My next step would be to download a trial version of Commview 3 - install it onto the client.

This App is an excellent packet sniffer and will show you exactly any traffic that is happening & to which IP Address it is going to

You could try and decipher the packets with this tool if you are brave - at very least it will show how much traffic is generated on which port to where.

GW