Page 1 of 1

Zoho CRM ODBC Driver and UniDac

Posted: Mon 31 Oct 2016 22:26
by maurix
Hi,
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=[email protected];Password=apassword;DetectFieldsOnPrepare=True"

I also tried to set the connection string in the way you suggested in the Documentation:
"Uid=[email protected];Pwd=******;SecurityToken=a6Lgob979LW4anxfbhtDgtukr"

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

What's wrong?

Thanks.

Re: Zoho CRM ODBC Driver and UniDac

Posted: Tue 01 Nov 2016 09:41
by AlexP
hello,

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