I have the same problems since years. The error 80  occures when someone sends a message with html-contents. I delete this message in outlook and then it works. I didn't found any...

I got the same error when I try to view a table:

"The query cannot be executed because some files are either missing or not registered.

Run setup again to make sure...

I don´t like passwords in my scripts concerning the openrowset-approach.

Use insert to put a resultsetset from a sp into a (temporary) table.

Example:

create table test(dirlines varchar(255) )

...

Hello, I found 2 interesting articles in the MS-Knowldgebase concerning this error that helped me with the same problem.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q241267

and

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q296711

Maybe it helps.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q296711

Thank you, Steve. You are right. I use another gateway on my client from where I can connect to mysql. But the sql-server uses another one. It took me some...