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
Showing posts with label mdac. Show all posts
Showing posts with label mdac. Show all posts
Thursday, March 22, 2012
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!
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!
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!
Sunday, February 26, 2012
Enterprise Manager crashes
Using SQL Server 2000 SP3 Developer Edition and MDAC 2.7
After installing SP3 to my desktop to inoculate against the Slammer worm, Enterprise Manager started crashing with the following whenever I try to open database properties with the following: The instruction at "0x4247b98b" referenced memory at "0x0000001c" could not be 'read'. I've reinstalled SQL Server and the MDAC to no avail. Has anyone else had this and are there any ideas for possible solutions?
ThanksYou might want to take a look at the error log to see which component is failing. There is a known issue with DTSUI.DLL after installing sp3. You will have to contact PSS to get the fix.
G'luck.|||Get SQLDMO.DLL from \Program Files\Microsoft SQL Server\80\Tools\Binn and SQLDMO.rll from Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033 and Register it again using the REGSVR32 command.
We use to have the same problem now everything seems to be working fine.|||I was never able to get sqldmo.rll to register, as regsvr32 said that it only liked to register dll's and ocx's. But, moving the 2 files to the system32 folder replaced some really old ones and fixed the problem. Thanks for your help!|||Just be carefule the next time when you uninstall any user application as it tends to take away the SQLDMO.dll,which again results in the same thing.
After installing SP3 to my desktop to inoculate against the Slammer worm, Enterprise Manager started crashing with the following whenever I try to open database properties with the following: The instruction at "0x4247b98b" referenced memory at "0x0000001c" could not be 'read'. I've reinstalled SQL Server and the MDAC to no avail. Has anyone else had this and are there any ideas for possible solutions?
ThanksYou might want to take a look at the error log to see which component is failing. There is a known issue with DTSUI.DLL after installing sp3. You will have to contact PSS to get the fix.
G'luck.|||Get SQLDMO.DLL from \Program Files\Microsoft SQL Server\80\Tools\Binn and SQLDMO.rll from Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033 and Register it again using the REGSVR32 command.
We use to have the same problem now everything seems to be working fine.|||I was never able to get sqldmo.rll to register, as regsvr32 said that it only liked to register dll's and ocx's. But, moving the 2 files to the system32 folder replaced some really old ones and fixed the problem. Thanks for your help!|||Just be carefule the next time when you uninstall any user application as it tends to take away the SQLDMO.dll,which again results in the same thing.
Subscribe to:
Posts (Atom)