MyNextHome
2009-02-17T12:40:00Z
Hi,

we are using Oracle 9 and Oracle ODBC driver.
During the sync, we get errors on queries generated by GeniusConnect like (from GeniusConnect SQL Log ):

select T1GC."T791_ID",T1GC."T791_T790_ID

Also, when we run the sync second time, Outlook/GeniusConnect crashes!
Administrator
2009-02-17T12:44:00Z
Hello,

-Do not use native Oracle ODBC driver, try to use Microsoft ODBC driver for Oracle or DataDirect ODBC drivers for Oracle.
Oracle ODBC drivers are very unstable!

-it looks like your Oracle version does not support ANSI quoted indentifiers
GoTo Assign Table dialog and uncheck the "Use ANSI quoted identifiers" checkbox
MyNextHome
2009-02-17T12:57:00Z
Thanks,

now we are getting error when storing attachments of a mail item.
The mail is inserted, but then we get error:
Attachment Error: select etc....
ORA-00997: illegal use of LONG datatype
Administrator
2009-02-17T13:03:00Z
Hello,

When storing/loading attachments, GeniusConnect adds "order by" to select the attachments from DB, sorted by Attachment number/index.

I guess you have mapped an oracle LONG datatype to Outlook column Attachment Number.

Cause: A value of datatype LONG was used in a function or in a DISTINCT,WHERE, CONNECT BY, GROUP BY, or ORDER BY clause. A LONG value can onlybe used in a SELECT clause.

You have to change the columns datatype.