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:
Create an ODBC data source directly to your Sybase
database using SequeLink ODBC.
Create a table with a column of datatype "TINYINT".
CREATE TABLE gulliver (lilliputian TINYINT)
Insert a value into the table.
INSERT INTO gulliver VALUES (1)
Observe that you can successfully retrieve this data without a problem.
SELECT * FROM gulliver
Close your connection to your ODBC data source for Sybase.
Create a Linked Server connection in SQL Server to Sybase using your SequeLink ODBC data source and MSDASQL as the provider.
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>"
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."