Kbase P35634: Error running query in SQL Server via Linked Server after Progress Database schema change
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/07/2009 |
|
Status: Verified
SYMPTOM(s):
Error running query.
Query ran successfully before column added or removed in table.
Same query runs without a problem via SQLExplorer.
Same query runs properly via third party SQL Tools that connect using the DSN entry.
Query failing uses the OpenQuery method calling the connect information from the Linked Server calling the DSN entry in the Enterprise Database Manager.
Server: Msg 7353, Level 16,
State 1, Line 1
OLE DB provider 'MSDASQL' supplied inconsistent metadata.
An extra column was supplied during execution that was not found at compile time.[Non-interface error: OLE DB provider returned an extra column at execution time: ProviderName='MSDASQL', ColumnName=<column name>',
Rowset="pub"."tablename"]."
FACT(s) (Environment):
Remote Progress database setup as Linked Server in SQL Server 2000
MS SQL 2000
Windows
CAUSE:
Microsoft Linked Server instance caches metadata for faster query resolution. This does not get properly refreshed when the Progress Database resides on a remote server. If Progress Database resides on the same machine as Linked Server instance, problem does not occur.
FIX:
Drop and re-add Linked Server instance in the Enterprise Manager. Contact Microsoft for more information.