The Zoho CRM Lead module has a system field name [No. of Employees]. The initial linking of the MS Access Data using the the DevArts ODBC connection to the ZOHO Lead table fails because of the period. The label "No. of Employees" is designated invalid. This is observed for Unicode or ANSI encoding string type configurations.
I asked ZOHO about this, but expect no change, This field is a system field. I cannot bracket the field label because it is in accessible. Access to other ZOHO tables like the contact table works fine so I know its not in the communication. I believe the parser does not properly escape the field labels and halts the connection.
Unfortunately all the action is in the LEAD table. This is where I need the ODBC access to optimize the data, manage marketing list, and update tracking information from other sources. Running version 2.4.1. The error has been validated by DevArts support but so far not corrective versions offered.
Zoho Tables with periods in field labels prevent table Access.
Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Jump to
- General Forums
- ↳ Announcements
- Database Tools
- ↳ dbForge for MySQL
- ↳ dbForge for Oracle
- ↳ dbForge for PostgreSQL
- ↳ dbForge for SQL Server
- ADO.NET Data Providers
- ↳ Entity Framework support
- ↳ LinqConnect (LINQ to SQL support)
- ↳ dotConnect for Oracle
- ↳ dotConnect for MySQL
- ↳ dotConnect for PostgreSQL
- ↳ dotConnect for SQLite
- ↳ dotConnect for DB2
- ↳ dotConnect for SQL Server
- ↳ dotConnect for Cloud Applications
- ↳ dotConnect Universal
- ↳ Entity Developer
- Delphi Data Access Components
- ↳ EntityDAC
- ↳ Universal Data Access Components
- ↳ Oracle Data Access Components
- ↳ SQL Server Data Access Components
- ↳ MySQL Data Access Components
- ↳ InterBase Data Access Components
- ↳ PostgreSQL Data Access Components
- ↳ SQLite Data Access Components
- ↳ VirtualDAC
- dbExpress Drivers
- ↳ dbExpress driver for Oracle
- ↳ dbExpress driver for SQL Server
- ↳ dbExpress driver for MySQL
- ↳ dbExpress driver for InterBase & Firebird
- ↳ dbExpress driver for PostgreSQL
- ↳ dbExpress driver for SQLite
- ODBC Drivers
- ↳ ODBC Drivers
- Network Security
- ↳ SecureBridge
- Developer Tools
- ↳ Code Compare
- ↳ Review Assistant
- ↳ LINQ Insight
- ↳ SSIS Data Flow Components
- ↳ Excel Add-ins