Remote query problem

[Craig Howe-Watson]

Hi all.

I get the following error when I attempt to execute a remote query :

Server: Msg 7351, Level 16, State 2, Line 1
OLE DB provider 'SQLOLEDB' could not map ordinals for one or more columns of
object 'DBSCHEMA_COLUMNS'.

Anybody seen this before and managed to fix it?

Many thanks.
Craig

[mimorr]

I've seen it many times and with Microsoft's help, I fixed it this way:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=20&messageid=13724

"Due to other problems I formatted this system and tried again. I
still received the error so I called Microsoft PSS. Worth the money!
I had wonderful patient assistance from Chandra who found that if the
instcat.sql doesn't install correctly from the service pack, this error
can be received. He worked to see if I could reapply the script to my
production box and found that it should be ok. We installed it and
everything works now. "