Error When quering Zoho from SSMS

[lozinak]

I the Zoho Driver for ODBC and I have created a linked server in SQL Management studio. When I try and query this data I get the following error:
query:
SELECT * FROM [zoho]...[Leads]

Error:
Msg 7355, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "zoho" supplied inconsistent metadata for a column. The name was changed at execution time.

Any idea??

Bob Lozinak
Twelve/Three Marketing, Inc.

[AlexP]

Hello,

Please specify the field types of the table used in the query

[lozinak]

Not sure what you mean by what field type. This is a standard install of Zoho. I would think the driver would work.

I have even tried this:
SELECT [Company] FROM [zoho]...[Leads]

and I get the same message:
Msg 7355, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "zoho" supplied inconsistent metadata for a column. The name was changed at execution time.

Please tell me how to fix.

Bob Lozinak

[AlexP]

Yes, such a bug was in the previous driver versions. It is already fixed in the latest version. Please download the latest driver version: https://www.devart.com/odbc/zoho/download.html , and check the behavior again.