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!

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

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

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.