Zoho CRM ODBC Driver and UniDac

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
Posts: 7
Joined: Wed 08 Oct 2008 17:48

Zoho CRM ODBC Driver and UniDac

Post by maurix » Mon 31 Oct 2016 22:26

I'm trying to connect to Zoho CRM using UniDac in Delphi 10.1 Berlin. I setup the API Token in the ODBC Data Source Administrator dialog and the test run successfully.

As soon as I try to connect via TUniConnection I receive the following error:
exception class : EUniError
exception message : [Devart][ODBC][Zoho CRM]Connection parameter name is unknown: PWD.

The connetion string is in UniConnection is:
"Provider Name=ODBC;Server=Devart Zoho Driver;User ID=user@mail.com;Password=apassword;DetectFieldsOnPrepare=True"

I also tried to set the connection string in the way you suggested in the Documentation:

But It seems I cannot use "Uid" or "Pwd" or "SecurityToken".

What's wrong?


Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Zoho CRM ODBC Driver and UniDac

Post by AlexP » Tue 01 Nov 2016 09:41


To connect with Zoho you need to input only SecurityToken. A password and a login are needed to access the site. In UniDAC you can just select a configured DSN.

P. S. We will fix our documentation in the near future

Post Reply