Reason General OLE Error 16386

Question

Reason General OLE Error 16386

Warnie (TechnicalUser)

(OP)

10 Jan 03 01:31

Hi,

I have a product which is designed for SQL 7.0.
Now I have tried to install it on SQL 2K and when I open the Enterprise manager to confirm that I can access my server databases, I am getting an error as below:

A connection could not be established to (servername)

Reason General OLE Error 16386

Please verify the SQL Server is running and check your SQL Server registration properties. How do I get out of this?
Any pointers will be welcome.

Thanks,
Warnie

JayKusch (MIS) · Answer 1 · 2003-01-10 10:55:43

Try This ...

a. Stop all SQL Server services (MSSQLServer, SQLServerAgent, MSSEARCH)

b. Open command prompt and go to the Program Files\Microsoft SQL Server\80\Tools\Binn directory

c. Unregistered the following .dll files
(Ex. regsvr32 /u dtsui.dll):

dtsui.dll, sqlns.dll, sqldmo.dll, sqllex.dll, sqlmmc.dll

d. Copy and paste the .dll files from a CD (under x86\Binn directory) to the
Program Files\Microsoft SQL Server\80\Tools\Binn

e. Register the .dll files (Ex. regsvr32 sqldmo.dll)

Thanks

J. Kusch

Warnie (TechnicalUser) · Answer 2 · 2003-01-13 01:05:03

Thanks Jay for the response.

It worked!! In conclusion, is my product setup corrupting the mentioned dlls? How do I get around this? Any pointers will be most welcome....

Warnie

JayKusch (MIS) · Answer 3 · 2003-01-13 09:39:35

Looks as if your third party app is in deed overwriting the DLLs for SS2K. Rather hard to give any pointers except to read the install notes prior to see if they have any bearing to SS2K and its associated files. Glad your back up and running!

Thanks

J. Kusch

Come Join Us!

Posting Guidelines

Jobs

Reason General OLE Error 16386