Bruce
2004-11-05T14:25:00Z
I have downloaded the Genius Connect software for evaluation. I need to assess its capabilities for backing up Outlook Contacts.

Having configured the neccessary blank MDB with a table a the approriate fields and configuring the Primary Key SQL Statement I get the following error when I try to Store Items

37000 [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. (-3502) (SyncFolder)

Do you have any suggestions/solutions

Regards
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2004-11-05T14:36:00Z
check the following:
-do not use space in column/table name ("ColumnID" not "Column ID")
or check the "ANSI quoted identifiers" checkbox
Bruce
2004-11-05T14:52:00Z
I haven't any spaces in either the column or table names - what about other characters - I have used () brackets
Administrator
2004-11-05T15:04:00Z
() can be also a problem.
Please, try also the example mdb see:
http://support.geniusconnect.com/Posts/t16- 
Bruce
2004-11-05T15:39:00Z
All working now - thanks
2004-12-05T09:32:00Z
I have just recently had a similar problem. I have been using this software for a number of weeks and has been working ok.

However, yesterday, I am now also receiving a similar 37000 error.

The only changes I have since it last worked are : a) re-installed Activesync 3.7.1 , b) installed the latest version 1.0.2.7

I have removed and re-installed, but still getting errors. I have also noticed that using an ODBC link from an MS Access database onto the MYSQL database, on Linux, that I can only perfom query and not update.

Any ideas on how this problem was previously resolved.
Administrator
2004-12-07T14:52:00Z
Please see:
http://support.geniusconnect.com/Posts/t98- 
(to disable ANSI SQL generation)