Page 1 of 1

Problem sending data back into Zoho

Posted: Fri 16 Dec 2016 16:54
by JohnM
Hello all,
First post.

I have installed the ODBC driver and now able to pull over all the Zoho tables and data. I'm now in the process of writing information back into Zoho via a product call Alpha Anywhere and using the Devart ODBC driver.
I connect to Zoho fine however, when sending the update I receive the following error:
[Devart][ODBC][Zoho CRM]Object 'Accounts' does not have field 'Account_Name'

I know the error is telling me the field does not match Zoho. Can any tell me the field name structure? I match what came out of Zoho and thought it would work.

My code:
sqlUpdateStatement = <<%txt%
UPDATE Accounts SET Account_Name = :New__Account_Name

Re: Problem sending data back into Zoho

Posted: Mon 19 Dec 2016 10:31
by MaximG
In our test environment the Accounts table has the field named «Account Name». Try to change your query in the following way:

Code: Select all

UPDATE Accounts SET «Account Name» = :New__Account_Name

Re: Problem sending data back into Zoho

Posted: Sat 07 Jan 2017 12:54
by alsinger
Hi All, JohnM,

My first post as well ...

JohnM, I am making contact as a fellow Alpha Anywhere developer, but hasten to add, unfortunately, I do not have any solutions for your issue.

Well done to you for getting as far as you have..Unfortunately, I am stuck with getting my Alpha Anywhere app to read the tables -

This is the connection string that Alpha generates for me


Any assistance getting past this block much appreciated

Error message is ... sp=sharing

Re: Problem sending data back into Zoho

Posted: Tue 10 Jan 2017 14:49
by MaximG
Please describe the detailed steps, which cause the described error in the Alpha Anywhere environment. If we correctly understand, the error occurs when you try to introduce changes to table "Accounts"?

Re: Problem sending data back into Zoho

Posted: Fri 13 Jan 2017 08:37
by alsinger
Hi Maxim,

My initial issue, as described in my first forum post, was due to the fact that I was following documentation on ZOHO CRM (and the DEVART DRIVER) that was out of date in respect of how to access and generate the authentication Token with the effect that I was not in fact using a valid authentication token in the driver configuration

Yesterday my time (Thursday 12th Jan) Devart support helped me out on showing me how the ZOHO interface is now very different to the current documentation and how I could navigate to the place where the authentication token could be generated - which I subsequently did and used in re-configuring the DEVART ZOHOCRM ODBC driver.

What I had been using (incorrectly) was the Zoho ZSC key. :shock:

But now having moved beyond that "blockage", I have been able to read records, and update records :D but once an initial action has been completed (or in the case of an insert, after the submit button for the input is clicked) , my program goes unresponsive -
This si strue for trying to display a second page of records, making a change to a record or inserting a record - the first operation is successful but control is not returned to the user and instead, the program becomes unresponsive.

SO, I have sent all the details to the development platform company for them to review - as well as a detailed message to DEVART support (to Alex)

Re: Problem sending data back into Zoho

Posted: Mon 03 Apr 2017 08:32
by MaximG
Please send all the prepared information on this issue via the e-support form ( menu "Support"\"Request Support" ) again. We are preparing to release a new build of our driver and will try to investigate and solve this problem in this release.