Zoho CRM ODBC Driver and UniDac

Zoho CRM ODBC Driver and UniDac

Postby maurix » Mon 31 Oct 2016 22:26

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=user@mail.com;Password=apassword;DetectFieldsOnPrepare=True"

I also tried to set the connection string in the way you suggested in the Documentation:
"Uid=zohouser@gmail.com;Pwd=******;SecurityToken=a6Lgob979LW4anxfbhtDgtukr"

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

What's wrong?

Thanks.
maurix
 
Posts: 7
Joined: Wed 08 Oct 2008 17:48

Re: Zoho CRM ODBC Driver and UniDac

Postby AlexP » Tue 01 Nov 2016 09:41

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


Return to ODBC Drivers