Remote query problem

Thread View: bit.databases.mssql-l

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Craig Howe-Watson Tue, 16 Mar 2004 13:44

#13

Author: Craig Howe-Watson
Date: Tue, 16 Mar 2004 13:44

12 lines
1709 bytes

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

Re: Remote query problem

#29

Author: mimorr
Date: Sun, 02 Jan 2005 23:07

11 lines
1654 bytes

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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads