Michael
2004-02-08T02:24:00Z
Hi,

When attempting to Store Item to MSDE database I get the following error -

37000 [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect Syntax near 'DF53'.
37000 [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared. (170)

I have a Primary Key field in the table which I have configured the select newid() as per your docs.

Any Ideas?
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2004-02-08T12:37:00Z
check the following:
-do not use space in column/table name ("ColumnID" not "Column ID")
or check the "ANSI quoted identifiers" checkbox

-is the outlook folder linked to a database VIEW?
check source of the view, if the view contains multiple tables or complex query
it is not possible to execute insert/update statements against the view (or you have to create "instead of triggers")

still problem's:
email us table/view Create script, and OutlookConnect ini file (export button on Assign Table dialog)