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.
Error When quering Zoho from SSMS
Re: Error When quering Zoho from SSMS
Hello,
Please specify the field types of the table used in the query
Please specify the field types of the table used in the query
Re: Error When quering Zoho from SSMS
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
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
Re: Error When quering Zoho from SSMS
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.