When I run a distributed query against a linked server connection to Sybase, I received the following error message:
Server: Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' supplied inconsistent metadata for a column. Metadata information was changed at execution time.
The linked server connection is valid, and the funny thing is that some queries run, but others fail with the message above. It seems to be table or view related, meaning that some tables off the linked server resolve queries without any problems, but others fail. I looked at the source fields on the sybase database, and nothing looked out of line. Can anybody provide a little light here?
Server: Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' supplied inconsistent metadata for a column. Metadata information was changed at execution time.
The linked server connection is valid, and the funny thing is that some queries run, but others fail with the message above. It seems to be table or view related, meaning that some tables off the linked server resolve queries without any problems, but others fail. I looked at the source fields on the sybase database, and nothing looked out of line. Can anybody provide a little light here?
