ZOHO ODBC with SSMS - Column names with spaces

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
haojiang11
Posts: 2
Joined: Thu 20 Apr 2017 23:43

ZOHO ODBC with SSMS - Column names with spaces

Post by haojiang11 » Fri 21 Apr 2017 01:48

Hi,

I'm using a linked server in SSMS to Zoho. How do I insert a row in a table with columns that have spaces in them?

I tried these:

Code: Select all

INSERT ZOHO...[Solutions] ([Solution Title]) VALUES ('TEST1')
I got error: Zoho CRM]Access violation at address 000000000063ADE7 in module 'DevartODBCZoho.dll'. Write of address 0000000000000094

Code: Select all

INSERT OPENQUERY (ZOHO, 'SELECT [Solution Title] FROM Solutions')  VALUES ('TEST1')
I got error: Unknown column '[Solution Title]

Code: Select all

INSERT OPENQUERY (ZOHO, 'SELECT "Solution Title" FROM Solutions')  VALUES ('TEST1')
I got error: Unexpected symbol ':'

Code: Select all

INSERT OPENQUERY (ZOHO, 'SELECT ''Solution Title'' FROM Solutions')  VALUES ('TEST1')
I got error: List index out of bounds (0)

Thank you.

MaximG
Devart Team
Posts: 1024
Joined: Mon 06 Jul 2015 11:34

Re: ZOHO ODBC with SSMS - Column names with spaces

Post by MaximG » Fri 26 May 2017 17:33

Thank you for the information. We reproduced the problem and fixed this bug. The fix will be included in the next build.

Post Reply