Error trying to connect via Enterprise Manager

[chelandrew]

Get a 'General OLE Error 16386' when trying to connect to remote sqlserver 2000 from enterprise manager client. Yet I can connect just fine with utilities like osql or query analyzer. I've checked connect properties and they are correct. Worked fine up until a few days ago. Reboot didn't help.

 

[gerh]

I too am getting this error.

Anyone know how to fix it?

Thanks

 

[tlbroadbent]

You may have installed software that replaced the sqldmo.dll file and the current file isn't compatible with SQL 2000. Check to see if you have two sqldmo.dll files on your PC. (sqldmo.dll should be in the SQL Server program folder - C:\Program Files\Microsoft SQL Server\80\Tools\Binn.)

If so do the following.
[ul][li]Unregister the older sqldmo.dll by running regsvr32 /u sqldmo.dll from a command prompt window
[li]Rename the old sqldmo.dll to sqldmo.old
[li]Register the newer sqldmo.dll by running regsvr32 sqldmo.dll from a command prompt window[/ul]If you only have one sqldmo.dll file, then make sure the version is 2000.080.nnnn.00. You may need to reinstall the correct version from the SQL install CD.

Let me know if this helps.
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Guest_imported]

The sqldmo.dll worked for me.