Error: "OLE DB provider 'MSDASQL' supplied inconsistent metadata for a column".

« Go Back


Question/Problem Description

When attempting to execute a SELECT statement in Query Analayzer via a SQL Server Linked Servers connection through SequeLink ODBC to a Sybase database, the error message returned is, "OLE DB provider 'MSDASQL' supplied inconsistent metadata for a column"

Steps to reproduce:

  1. Create an ODBC data source directly to your Sybase
    database using SequeLink ODBC.


  2. Create a table with a column of datatype "TINYINT".

    CREATE TABLE gulliver (lilliputian TINYINT)


  3. Insert a value into the table.

    INSERT INTO gulliver VALUES (1)


  4. Observe that you can successfully retrieve this data without a problem.

    SELECT * FROM gulliver


  5. Close your connection to your ODBC data source for Sybase.

  6. Create a Linked Server connection in SQL Server to Sybase using your SequeLink ODBC data source and MSDASQL as the provider.

  7. Open Query Analyzer and attempt to execute a SELECT statement against the Sybase database using four part naming syntax:

    "SELECT * FROM <LinkedServerName>.<CatalogName>.<SchemaName>.<TableName>"


  8. The error message returned is as follows:

    "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."
Clarifying Information
Error Message
Defect/Enhancement Number

Use OPENQUERY syntax to query your Linked Server connection as a work-around to this error.

Using the same Linked Server connection as before, execute the following command in Query Analyzer:

"SELECT * FROM OPENQUERY (<LinkedServerName>, "SELECT * FROM <TableName>")"

Was this article helpful?


Your feedback is appreciated.

Please tell us how we can make this article more useful.

Characters Remaining: 255


Copyright © 1993-2014. Progress Software Corporation. All Rights Reserved. See the next generation of application development and data connectivity software, try now!