Article

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

« Go Back

Information

 
Environment
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
Cause
Resolution


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

Workaround
Notes
Attachment 
Feedback
 
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!