enterprise manager on Windows XP x64

I have just installed Windows XP Pro x64 on new computer and having hard
time installing enterprise manager (SQL Server 2000) to connect to my SQL
2000 Server running on remote machine.
Is there any version of SQL Client Tools for x64 or I have to purchase SQL
Server 2005.
Thanks,
Vlado"Vlado Jasovic \(www.excelleinc.com\)" <vjasovicATexcelleincDOTcom>
wrote in news:LIydnU5LKY-WLuLenZ2dnUVZ_tidnZ2d@.giganews.com:
> I have just installed Windows XP Pro x64 on new computer and having
> hard time installing enterprise manager (SQL Server 2000) to connect
> to my SQL 2000 Server running on remote machine.
You can install and run the 32-bit version of Enterprise Manager. As far as
I know there is no 64-bit version of it.
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging

enterprise manager on Windows XP x64

I have just installed Windows XP Pro x64 on new computer and having hard
time installing enterprise manager (SQL Server 2000) to connect to my SQL
2000 Server running on remote machine.
Is there any version of SQL Client Tools for x64 or I have to purchase SQL
Server 2005.
Thanks,
Vlado
"Vlado Jasovic \(www.excelleinc.com\)" <vjasovicATexcelleincDOTcom>
wrote in news:LIydnU5LKY-WLuLenZ2dnUVZ_tidnZ2d@.giganews.com:

> I have just installed Windows XP Pro x64 on new computer and having
> hard time installing enterprise manager (SQL Server 2000) to connect
> to my SQL 2000 Server running on remote machine.
You can install and run the 32-bit version of Enterprise Manager. As far as
I know there is no 64-bit version of it.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging

enterprise manager on Windows XP x64

I have just installed Windows XP Pro x64 on new computer and having hard
time installing enterprise manager (SQL Server 2000) to connect to my SQL
2000 Server running on remote machine.
Is there any version of SQL Client Tools for x64 or I have to purchase SQL
Server 2005.
Thanks,
Vlado"Vlado Jasovic \(www.excelleinc.com\)" <vjasovicATexcelleincDOTcom>
wrote in news:LIydnU5LKY-WLuLenZ2dnUVZ_tidnZ2d@.giganews.com:

> I have just installed Windows XP Pro x64 on new computer and having
> hard time installing enterprise manager (SQL Server 2000) to connect
> to my SQL 2000 Server running on remote machine.
You can install and run the 32-bit version of Enterprise Manager. As far as
I know there is no 64-bit version of it.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging

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 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.