Error When quering Zoho from SSMS

Error When quering Zoho from SSMS

Postby lozinak » Tue 21 Jun 2016 15:51

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.
lozinak
 
Posts: 2
Joined: Tue 21 Jun 2016 15:46

Re: Error When quering Zoho from SSMS

Postby AlexP » Fri 24 Jun 2016 13:55

Hello,

Please specify the field types of the table used in the query
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35

Re: Error When quering Zoho from SSMS

Postby lozinak » Tue 28 Jun 2016 17:57

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
lozinak
 
Posts: 2
Joined: Tue 21 Jun 2016 15:46

Re: Error When quering Zoho from SSMS

Postby AlexP » Mon 11 Jul 2016 11:29

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.
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35


Return to ODBC Drivers